MODS.DB9.DK

[lefteris]

Couldn't update/insert into banners table

DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'http://www.support-page.gr/logo.gif', '1', '0', 'Support', 'w

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) VALUES (, 'http://www.support-page.gr/logo.gif', '1', '0', 'Support', 'www.support-page.gr', '100', '100', '2', '-1', '2', '0', '0', '0', '0', '0', '0')

Line : 540
File : C:\dokimi\phpbb2\admin\admin_banner.php



I have All Ready Run Db_update.php

My Sql Run Perfect.


What i have to do for this?

[Niels]

It seam like the newly updated admin_banner.php have a bug, only new installations will show this error.

I have updated the file, and uploaded it to the zip, please update this file, and you should be up and runing

[wakke]

I get the same error. Tried to overwrite all files again without success:

Couldn't update/insert into banners table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''50','50','0','600','50')' at line 2

INSERT INTO boardersforum_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','uploads/banner_small_test.jpg', '1', '5', 'banner small test', 'http://www.google.be', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', 'banner small test','0',ø'50','50','0','600','50')

Line : 616
File : /usr/local/psa/home/vhosts/jeugdcontact.be/httpdocs/site/admin/admin_banner.php

[wakke]

I found it , I just removed this sign from the code:

ø

[Billy2423]

Thank you wakke, I was looking for that also..

[bacalhau_cnatas]

You can find the solution for that problem here

http://mods.db9.dk/viewtopic.php?t=5891&start=0