4KIST

Advertisments PROBLEM !

Recommended Posts

Evening Everyone, I'm asking for a great help with the problem with ads on the Roleplay OWL server! What do I have to do and what to do in the database?

ERROR: advertisements\advertisements.lua:117: call: failed to call 'mysql:select' [string "?"]
 ERROR: advertisements\advertisements.lua:117: bad argument #1 to 'ipairs' (table expected, got boolean)

this ad structure is good to the database is from the OWL gamemode?

CREATE TABLE `advertisements` (
  `id` int(11) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `name` varchar(50) NOT NULL,
  `address` varchar(100) NOT NULL,
  `advertisement` text NOT NULL,
  `start` int(11) NOT NULL,
  `expiry` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `section` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

and please nice can you give me a good ad resource and structure to go on the server!
Thank you for your support!

 

Edited by 4KIST

Share this post


Link to post

Either way you don't have a connection to your MySQL database or the table/entry does not exist.

Use /debugdb and check the MySQL logs for detailed error messages.

Share this post


Link to post
11 hours ago, Sorata_Kanda said:

Either way you don't have a connection to your MySQL database or the table/entry does not exist.

Use /debugdb and check the MySQL logs for detailed error messages.

where use /debugdb? in localserver?

Share this post


Link to post

debugdb: You do not have sufficient rights to use this command.

im level 9 admin !

Share this post


Link to post
12 hours ago, Sorata_Kanda said:

Either way you don't have a connection to your MySQL database or the table/entry does not exist.

Use /debugdb and check the MySQL logs for detailed error messages.


[2019-01-26 12:39:09] ERROR: [Server]\advertisements\advertisements.lua:94: call: failed to call 'mysql:select' [string "?"]
[2019-01-26 12:39:09] ERROR: [Server]\advertisements\advertisements.lua:94: bad argument #1 to 'ipairs' (table expected, got boolean)
[2019-01-26 12:39:57] ERROR: [Server]\advertisements\advertisements.lua:94: call: failed to call 'mysql:select' [string "?"]
[2019-01-26 12:39:57] ERROR: [Server]\advertisements\advertisements.lua:94: bad argument #1 to 'ipairs' (table expected, got boolean)

Edited by 4KIST

Share this post


Link to post
2 minutes ago, Sorata_Kanda said:

Asigurați-vă că există conexiunea MySQL? 

Yes is exists connection the MySQL

Share this post


Link to post
On 26/01/2019 at 13:08, 4KIST said:

Yes is exists connection the MySQL

 

On 26/01/2019 at 12:04, 4KIST said:


[2019-01-26 12:39:09] ERROR: [Server]\advertisements\advertisements.lua:94: call: failed to call 'mysql:select' [string "?"]
[2019-01-26 12:39:09] ERROR: [Server]\advertisements\advertisements.lua:94: bad argument #1 to 'ipairs' (table expected, got boolean)
[2019-01-26 12:39:57] ERROR: [Server]\advertisements\advertisements.lua:94: call: failed to call 'mysql:select' [string "?"]
[2019-01-26 12:39:57] ERROR: [Server]\advertisements\advertisements.lua:94: bad argument #1 to 'ipairs' (table expected, got boolean)

Because this looks like the query you sent to your MySQL database doesn't return your values. Did you look up in the debug log files of /debugdb? Send some lines where it occurs.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.