| Author |
Post |
|
|
#1 Mon Dec 26, 2005 3:38 am
|
|
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. »
|
|
|
#2 Mon Dec 26, 2005 4:19 am
|
|
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.
|
|
|
#3 Mon Dec 26, 2005 12:22 pm
|
|
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
|
Set debug to 2 and try again, and post the erroneous SQL query.
|
|
|
#4 Thu Jan 05, 2006 2:48 am
|
|
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.6download: http://cvs.sourceforge.net/viewcvs.py/*checkout*/usebb/UseBB/sources/admin_members.php
|
|
|
#5 Thu Jan 05, 2006 6:57 pm
|
|
Developer
Registered: Apr 2004
Posts: 2230
Location: Belgium
|
Indeed, fixed in CVS. 
|
|
|
#6 Tue Jan 10, 2006 2:46 am
|
|
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
|
|
|
#7 Tue Jan 10, 2006 10:55 am
|
|
Member
Registered: Apr 2004
Posts: 79
Location: Brussels Belgium
|
Did you edit you config.php file ? 
|
|
|
#8 Tue Jan 10, 2006 11:51 am
|
|
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.
|
|
|
#9 Thu Jan 12, 2006 10:24 am
|
|
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.6Please 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.
|
|
|
#10 Thu Jan 12, 2006 11:41 am
|
|
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.
|