NineChime forum
Furry stuff, oekaki stuff, and other stuff.
You are not logged in.
#1 09-16-2007 13:46:44
- Frostyfrog
- New member
Error messages on screen and login problems
I followed the instuctions at http://www.ninechime.com/forum/viewtopic.php?id=626 and I've tried everything that I could think of.
On the top of the index page I get:
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\wacpoteto-1.3.9\oekaki\common.php on line 446 Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\wacpoteto-1.3.9\oekaki\header.php on line 92 Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\wacpoteto-1.3.9\oekaki\header.php on line 119
On the bottom of the index page I get:
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\wacpoteto-1.3.9\oekaki\index.php on line 72 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\wacpoteto-1.3.9\oekaki\index.php on line 75
and when I try to login I get: No mode. Is a server filter being used?
can someone help me? I have full mysql, web server, and PHP control.
Offline
#2 09-16-2007 13:51:33
- Frostyfrog
- New member
Re: Error messages on screen and login problems
oops, I posted in here because I couldn't find the "OekakiPoteto v5.x" board.
Edit: I meant that I had this version, Wacintaki 1.3.9
Last edited by Frostyfrog (09-16-2007 14:21:40)
Offline
#3 09-16-2007 23:35:58
- Waccoon
- Administrator
Re: Error messages on screen and login problems
For some reason the database tables are not being created properly. The installer is supposed to print errors if table creation fails.
Do you have a screenshot or copy/paste of the output from the installer? So long as the database tables are empty, you can try re-installing the board on top of itself without having to delete any files. So, if you want to check if the installer returns errors, just run the installer again.
Do you know what version of PHP and MySQL your server has installed?
Offline
#4 09-17-2007 15:46:14
- Frostyfrog
- New member
Re: Error messages on screen and login problems
MySQL client version: 5.0.22
Code:
Wrote database config file... Wrote config file... Wrote base “resource” folder files... Starting to set up database... BLOB/TEXT column 'usrpass' can't have a default value [members] Table 'oekaki.op_oekaki' doesn't exist [admin] BLOB/TEXT column 'comment' can't have a default value [chat] BLOB/TEXT column 'comment' can't have a default value [comment] BLOB/TEXT column 'comment' can't have a default value [data] BLOB/TEXT column 'onlineIP' can't have a default value [online] BLOB/TEXT column 'subject' can't have a default value [mailbox] BLOB/TEXT column 'comment' can't have a default value [chat_mod] Duplicate entry '1' for key 1 [piccount] Duplicate entry '2' for key 1 [dbversion] Finished setting up database...
PHP Version 5.2.1
Is any of this helpful?
Edit: I am trying to make it log into the database as the root user. if you need my php info I have posted it here: http://www.freewebs.com/colton_w_frogette/phpinfo.html
Last edited by Frostyfrog (09-17-2007 17:59:33)
Offline
#5 09-20-2007 06:01:22
- Waccoon
- Administrator
Re: Error messages on screen and login problems
Oh, look... another MySQL inconsistency.
Well, I assume that you're using the Windows version of MySQL, and that version has different and more strict error reporting than the Unix version. Either that, or your particular MySQL package is just set to strict mode. Either way, one version of MySQL will report more errors and the installation will fail, while the other version will just ignore errors and install as normal.
Until I fix this properly, here's a workaround:
Inside the MySQL folder, there is a file called "my.ini" (Windows version) or "my.cnf" (Unix version). Open it up in a text editor, and look for the declaration of sql-mode. It will probably contain the flag STRICT_ALL_TABLES. Remove that flag, and you should be able to install the board.
The sad thing is that I actually had to add default values to text fields in the past to solve a standards-compliance issue. Now, they want me to remove the default values I added?
Offline
#6 09-21-2007 16:08:06
- Frostyfrog
- New member
Re: Error messages on screen and login problems
I think the servers that host PHP pages and use MySQL have already dealt with the problem for their customers. The line of code that I saw when editing my.ini:
Code:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" I changed it to: sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
and yes, i'm using the windows version.
Offline
#8 09-22-2007 22:39:50
- Frostyfrog
- New member
Re: Error messages on screen and login problems
No, I don't think so. Ya it works now.
Offline
#10 11-17-2007 11:07:13
- Frostyfrog
- New member
Re: Error messages on screen and login problems
I know a bit more about PHP and MySQL now.
I read my mysql server config ini file and got this:
default-storage-engine=INNODB
Offline