Having DB problems...

a complete banner management system, any number of banners can be added
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

Having DB problems...

Postby Fuzzy1 on Fri 30. Sep, 2005 23:07

I get this error when I try and upload a banner..

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','http://www.fuzzy-riders.com/banners/banner1.gif', '1', '0', 'Ken', 'http://www.kenbarber.ca', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', 'Ken Barber','0',ø'0','0','0','600','50')

Line : 616
File : admin_banner.php
User avatar
Fuzzy1
Poster
Poster
 
Posts: 47
Joined: Fri 25. Oct, 2002 19:06

Postby Fuzzy1 on Sat 01. Oct, 2005 00:01

ok.. Now I get:

Code: Select all
Couldn't update/insert into banners table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ''122','55','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','http://www.fuzzy-riders.com/phpBB2', '1', '0', 'Ken Barber', 'http://www.kenbarber.ca', '0', '0', '125', '-1', '2', '0', '0', '0', '0', '0', 'Ken Barber','0',ø'122','55','0','600','50')

Line : 616
File : admin_banner.php
User avatar
Fuzzy1
Poster
Poster
 
Posts: 47
Joined: Fri 25. Oct, 2002 19:06

Postby Beeveer on Sun 02. Oct, 2005 11:49

Update admin_banners.php with the file in the download here. That one is fixed.
Nee, ik geef geen antwoorden in het Nederlands, die horen thuis op www.phpbb.nl ;)
User avatar
Beeveer
brilliant supporter
 
Posts: 264
Joined: Tue 30. Nov, 2004 19:13
Location: Boskoop, South-Holland, the Netherlands

Postby Emuman on Sat 29. Oct, 2005 09:42

Thank you...
Emuman
Poster
Poster
 
Posts: 1
Joined: Wed 12. Oct, 2005 00:36


Return to Complete banner [2.0.6/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron