advertisments Advertisments PROBLEM !

[4KIST]

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 January 25, 2019 by 4KIST

[Sorata_Kanda]

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.

[4KIST]

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?

[Dimos7]

On your server 

[4KIST]

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

im level 9 admin !

[4KIST]

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 January 26, 2019 by 4KIST

[Sorata_Kanda]

Did you make sure the MySQL connection exists? 

[4KIST]

2 minutes ago, Sorata_Kanda said:

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

Yes is exists connection the MySQL

[Sorata_Kanda]

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.