Help Needed...

[lifedeuce]

I'm getting the following error when using the admin section of my phpBB forum:

Couldn't update forum information

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 'prune_enable = 0 WHERE forum_id = 9' at line 2

UPDATE phpbb_forums SET forum_name = 'Browns News', cat_id = 1, forum_desc = 'Get all the latest Cleveland Browns news right here! Everything from the latest trades, cuts, injuries and more! ', forum_status = 0, forum_icon = '' prune_enable = 0 WHERE forum_id = 9

Line : 474
File : /home/dawgbon/public_html/phBB/admin/admin_forums.php

Any ideas what might be wrong?

[Horus Kol]

you're missing a comma in your SET:


forum_icon = '', prune_enable = 0

[lifedeuce]

Horus how can I get the comma in? I use phpmyadmin. I just don't know how to make the fix, can you help? Thanks.

[Horus Kol]

oh, i see - its a problem in the phpBB script....

that's bad - i use that myself.

are you up-to-date with the version of phpBB?
If you are, I think you sould report this.

as for performing the query in phpMyAdmin... basically, just copy this into the query box in phpMyAdmin:


UPDATE phpbb_forums SET forum_name = 'Browns News', cat_id = 1, forum_desc = 'Get all the latest Cleveland Browns news right here! Everything from the latest trades, cuts, injuries and more! ', forum_status = 0, forum_icon = '', prune_enable = 0 WHERE forum_id = 9

[lifedeuce]

Horus where exactly would I do this inside phpmyadmin? Thanks.

[lifedeuce]

If I update phpBB, will I lose my forums and all the content? How can I find out if I'm running the latest version? This is what it says at the bottom of my forum: Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group

[marek_mar]

Umm yes 2.0.8 is the version number. You are far behind as 2.0.11 is the newest. Some critical errors have been fixed in the new versions (security). You wont loose any data when you upgrade (but backup the db and the files anyway).

[lifedeuce]

Marek how do you update to the newest version?

[lifedeuce]

I've upgraded to 2.0.11 of phpBB but I'm getting the same error message inside the admin section, under forum administration where you can edit each forum. Once in the editing section I have choices like forum name, forum icon, forum description and so on. I want to update the description so I type in something new and hit update and I get:

Couldn't update forum information

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 'prune_enable = 0 WHERE forum_id = 9' at line 2

UPDATE phpbb_forums SET forum_name = 'Browns News', cat_id = 1, forum_desc = 'Get all the latest Cleveland Browns news right here! Everything from the latest trades, cuts, injuries and more! ', forum_status = 0, forum_icon = '' prune_enable = 0 WHERE forum_id = 9

Line : 474
File : /home/dawgbon/public_html/phBB/admin/admin_forums.php

[Horus Kol]

it's still missing the comma....

This is something wrong in the script, and needs to be fixed by the guys at phpBB - have you informed them? They have their own support forums.

[lifedeuce]

I haven't contacted them, do you now how I can? Thanks foryour help by the way.

[Brandoe85]

You can try their forums http://www.phpbb.com/phpBB/