MODS.DB9.DK

[Argzors]

I have just tried to add a new banner for the first time but got this message. Does anyone know what the problem may be?

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 ''488','127','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','
Military Odyssey - 27th, 28th & 29th August 2005', '1', '3', 'Military Odyssey', 'http://www.military-odyssey.fsnet.co.uk/', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', 'Mil Odd banner','4',ø'488','127','0','600','50')

Line : 616
File : /home/wwiireen/public_html/forum/admin/admin_banner.php

[Argzors]

I think it is something to do with that ø symbol, I've removed it and played with the code and now it says it has added the banner - but it doesn't display on the forum.

It is supposed to be displaying here - http://www.wwiireenacting.co.uk/forum/viewforum.php?f=1

I can update the options for it and they are changed in the registry but it's just not displaying. I HAVE updated the tpl files.

Help!

[rew2]

check this http://mods.db9.dk/viewtopic.php?t=5891

[jupro]

Hi there,

I had a similar problem.

I think it is something to do with that ø symbol, I've removed it and played with the code and now it says it has added the banner - but it doesn't display on the forum.

After removing the symbol, my banner does display, but the image size gets set to 468x468 if I try and edit the banner properties. I followed the link provided http://mods.db9.dk/viewtopic.php?t=5891, and even changed the SQL,

Code: Select all

banner_height  mediumint(5)    UNSIGNED Nie  50
and
banner_width  mediumint(5)    UNSIGNED Nie  400

but it did not solve the problem.

Does anyone know what is going on here?

Thanks very much.

- Justin

[darakhshan]

I do not have that symbold
what can I do?

even the banners in this board most of the time is broken, how stupid I am to come back here again