MODS.DB9.DK

[XP-Rene]

When I added all information about a banner I want to add, I get the following error message:

Code: Select all

Couldn't update/insert into banners table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ''0','0','0','600','50')' at line 2

INSERT INTO phpbb_banner (banner_id, banner_name, banner_active, banner_spot, banner_description, banner_url, banner_click, banner_view, banner_owner, banner_level, banner_level_type, banner_timetype, time_begin, time_end, date_begin, date_end, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time,banner_weigth) VALUES ('1','images/banners/logo_wase.gif', '1', '0', 'Wase DB', 'http://www.wasedierenbescherming.com', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', '','0',ø'0','0','0','600','50')

Line : 616
File : /home/virtual/site113/fst/var/www/html/fotohoek/admin/admin_banner.php


What did I do wrong, and how can I solve this?

[Jeremy Toaster]

When I added all information about a banner I want to add, I get the following error message:

Code: Select all

Couldn't update/insert into banners table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ''0','0','0','600','50')' at line 2

INSERT INTO phpbb_banner (banner_id, banner_name, banner_active, banner_spot, banner_description, banner_url, banner_click, banner_view, banner_owner, banner_level, banner_level_type, banner_timetype, time_begin, time_end, date_begin, date_end, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time,banner_weigth) VALUES ('1','images/banners/logo_wase.gif', '1', '0', 'Wase DB', 'http://www.wasedierenbescherming.com', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', '','0',ø'0','0','0','600','50')

Line : 616
File : /home/virtual/site113/fst/var/www/html/fotohoek/admin/admin_banner.php


What did I do wrong, and how can I solve this?

See that little funky ZERO

,'0',ø'0',

I have found that if you REMOVE that and submit the SQL query again, it will go through...

Although I am having other issues....not sure if that is the case.

[XP-Rene]

Thanks a lot Jeremy Toaster, problem solved.

[Jeremy Toaster]

Yea everytime I insert a new banner I get that error, and have to manually put submit the SQL into the database while removing that FUCNKY zero...strange

[XP-Rene]

After changing this strange zero into a normal one, I had no longer any errors, so I don't know what's wrong in your database.

Actually it's not a 0 (zero) but an ø (as in diameter)

This are now working prober at my site