Help Needed...

lifedeuce · 01-26-2005, 09:44 PM

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 · 01-27-2005, 10:55 AM

you're missing a comma in your SET:

Quote:

forum_icon = '', prune_enable = 0

lifedeuce · 01-27-2005, 03:37 PM

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 · 01-27-2005, 04:50 PM

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:

Code:

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 · 01-27-2005, 07:37 PM

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

lifedeuce · 01-27-2005, 08:04 PM

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 · 01-27-2005, 08:32 PM

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 · 01-27-2005, 10:11 PM

Marek how do you update to the newest version?

lifedeuce · 01-28-2005, 05:01 AM

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 · 01-28-2005, 09:26 AM

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 · 01-28-2005, 11:24 PM

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

Brandoe85 · 01-29-2005, 12:05 AM

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

01-26-2005, 09:44 PM	PM User \| #1
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	Help Needed... 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?

01-27-2005, 04:50 PM	PM User \| #4
Horus Kol Regular Coder Join Date: Nov 2004 Location: Somewhere over the rainbow Posts: 208 Thanks: 0 Thanked 0 Times in 0 Posts	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: Code: 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 __________________ Questions are what binds the universe, Questions lead to answers, Answers lead to knowledge, Knowledge leads to wisdom, Wisdom brings more questions -- Horus Kol, 2004 :)

01-27-2005, 08:32 PM	PM User \| #7
marek_mar Sensei Join Date: Aug 2003 Location: One step ahead of you. Posts: 2,815 Thanks: 0 Thanked 3 Times in 3 Posts	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). __________________ I'm not sure if this was any help, but I hope it didn't make you stupider. Experience is something you get just after you really need it. PHP Installation Guide Feedback welcome.

01-28-2005, 09:26 AM	PM User \| #10
Horus Kol Regular Coder Join Date: Nov 2004 Location: Somewhere over the rainbow Posts: 208 Thanks: 0 Thanked 0 Times in 0 Posts	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. __________________ Questions are what binds the universe, Questions lead to answers, Answers lead to knowledge, Knowledge leads to wisdom, Wisdom brings more questions -- Horus Kol, 2004 :)

01-29-2005, 12:05 AM	PM User \| #12
Brandoe85 teh Moderatorinator Join Date: Sep 2004 Location: USA Posts: 2,435 Thanks: 2 Thanked 38 Times in 38 Posts	You can try their forums http://www.phpbb.com/phpBB/ __________________ -Brando Why using tables for eating is stupid!

01-27-2005, 03:37 PM	PM User \| #3
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	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.

01-27-2005, 07:37 PM	PM User \| #5
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	Horus where exactly would I do this inside phpmyadmin? Thanks.

01-27-2005, 08:04 PM	PM User \| #6
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	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

01-27-2005, 10:11 PM	PM User \| #8
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	Marek how do you update to the newest version?

01-28-2005, 05:01 AM	PM User \| #9
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	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

01-28-2005, 11:24 PM	PM User \| #11
lifedeuce New to the CF scene Join Date: Jul 2003 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts	I haven't contacted them, do you now how I can? Thanks foryour help by the way.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: