Furry stuff, oekaki stuff, and other stuff.
You are not logged in.
INNODB is fine. MyISAM is the default, and is more efficient for software that doesn't use transactions. INNODB adds transaction support to MySQL and is a bit slower.
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
For anyone else having this problem, 1.3.10 now correctly supports MySQL 5 strict mode.
No, I don't think so. Ya it works now.
STRICT_TRANS_TABLES is only supposed to enable strict mode with the transitional table engine. Is your default engine set to MyISAM? Is the installer actually working, now?
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:
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.
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?
MySQL client version: 5.0.22
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
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?
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