UseBB Community

UseBB support, discussion and development

[FIXED] SQL error on edit members with custom table prefix

Post Reply

Page: 1

Author Post
Member
Registered: Dec 2005
Posts: 5
Alright, searched for this and didn't see anything mentioned, so I'll throw up my situation. Considering my board is not modded at all; (I just recently installed it) I expect this to be a bug.

Before I begin, I am running PHP 4.4.1, and MySQL 4.0.25.

I go to ACP --> Edit members, and, I get the following error:

Quote
In file db_mysql.php on line 113:

SQL_ERROR - Fatal SQL error!

Enable debug mode level 2 to see the error and erroneous SQL query.


Just to let ya know. ;)
« Last edit by Dietrich on Sat Jan 07, 2006 1:53 pm. »
Member
Registered: May 2005
Posts: 386
Location: US WA. St.
Not 100% positive, try chmodding sessions.php in the sources directory to 666 or 777.

That is if you don't already know the fix or possible fix.
_______________
My board started January 03, 2012 and is powered by UseBB.
- wimc message board
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
Set debug to 2 and try again, and post the erroneous SQL query.
Member
Registered: May 2005
Posts: 26
Location: Japan
I also encountered this problem. And it solved.
This problem has a problem, when prefix of a table is changed.(i.e. "test_usebb")
As for the causality, prefix is not specified as a table by SQL.
This is solved on CVS.
Probably, if it exchanges for the file of CVS, it will solve.

diff:
http://cvs.sourceforge.net/viewcvs.py/usebb/UseBB/sources/admin_members.php?r1=1.5&r2=1.6
download:
http://cvs.sourceforge.net/viewcvs.py/*checkout*/usebb/UseBB/sources/admin_members.php
_______________
--
Tadashi "ELF" Jokagi http://poyo.jp/
HotPHPPER News: http://news.hotphpper.net/
Japan PHP Users group BBS: http://bbs.php.gr.jp/
Sorry, all contents are Japanese;-(
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
Indeed, fixed in CVS. :)
Member
Registered: Jan 2006
Posts: 1
I used /UseBB/install/index.php to configure my board.
I was then transfered to /UseBB/install/index.php?step=2, I clicked "Continue installation".

At /589/UseBB/install/index.php?step=2, I receive the error:

Quote
In file db_mysql.php on line 113:

SQL_ERROR - Fatal SQL error!

Enable debug mode level 2 to see the error and erroneous SQL query.


I unfortunately do not understand ELF's english very well, so I have a little trouble fixing my problem.
If I need to use CVS (which I am not experienced with), what is it that I need to do?

If the problem is an un-updated file, why was the old version not written over before the newest distribution?

Thanks
Member
Registered: Apr 2004
Posts: 79
Location: Brussels Belgium
Did you edit you config.php file ? :)
_______________
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
Please set debug to 2 (in config.php) and post the complete error.

This bug was fixed in CVS and is not yet included in a stable release, since there has not been a new release yet.
Member
Registered: May 2005
Posts: 26
Location: Japan
skape,

Sorry, I am not so good at English.

Please see this:
http://cvs.sourceforge.net/viewcvs.py/usebb/UseBB/sources/admin_members.php?r1=1.5&r2=1.6

Please observe the yellow part of Line 45 and Line 356 of this page.
A left block is UseBB 0.7, a file path is UseBB/sources/admin_members.php.
A right block is CVS.

Please back up file first.
Next, Please modify an applicable file like a right block.

Probably, a problem is solvable.
If a new problem occurs, please restore a file from backup.
_______________
--
Tadashi "ELF" Jokagi http://poyo.jp/
HotPHPPER News: http://news.hotphpper.net/
Japan PHP Users group BBS: http://bbs.php.gr.jp/
Sorry, all contents are Japanese;-(
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
skape wrote
At /589/UseBB/install/index.php?step=2, I receive the error:

This is in install/, I don't see how this could fix that problem.

Post Reply

Page: 1

UseBB Community is powered by UseBB 1 Forum Software