[SOLVED] Error after upgrade

[MHolkamp]

After my upgrade from 0.9.9.5 to 1.0.0.0 i recieve a error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 113

When i try to see the data.
The data in the database is still there.
Anyone some idea?

[admin]

Hi,

you did run update.php?

If yes i will try to reproduce this this evening.

regards,
Frank

[martin]

Hi,
  just for info: I have the same error after dowing a new installation.

Regards,
Martin

[admin]

Hi,

i did not have this problem after fresh installation.

What mysql/php/apache version are you using?

Could you set in your app.ini in section development the sqldebug to 1.
After that you will see all sql statements in the browser.
Could you create a screenshot of the hole window with the error and the sql statements?

regards,
Frank

[martin]

Hi,
  my fault: I´m using mysql server version 5.5.8. Not all tables where created during the install. In this mysql version the CREATE TABLE statment no longer supports the TYPE qualifier. I used the new qualifier ENGINE and now the tables were created.

Just one other error, maybe also caused by my mysql server version?

"Strict Standards: Declaration of db::connect() should be compatible with that of db_core::connect() in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 160"

Regards,
Martin

~~~~~~~~~~~~~~
PHP Version: 5.3.5
OS: WINNT
Server Software: Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1

[admin]

Hi,

@martin:
i will fix the initial dumps and will change the type qualifier to engine.

@MHolkamp:
The mysql upgrade dump was broken *damn* I will fix it.

I will fix both problem and will release a version 1.0.1 hopfully today.

Thanks for error reporting

regards,
Frank

[admin]

Hi,

bugfix release is available.
Feedback is welcome

regards,
Frank

[MHolkamp]

GREAT JOB.

The fix works for me.
Just copied the files and run update.php.
Knowledgeroot runs great again.

Thanks
Martin Holkamp

[MHolkamp]

Stil a little problem.
When i try to logon to the admin part this is what i see:



I tried to create a new admin.
But with that admin still the same problem.

[admin]

Hi,

try a fresh installation please.
Or drop all tables in the database and import the mysql.sql to that database.

regards,
Frank

[MHolkamp]

You mean, drop al tables and restore the backup?
Or drop al tables create new tables and restore the backup?

[admin]

Sorry, my fault

I thought you did a fresh install and no update.

So drop all tables. Restore the backup and do the update or run the upgrade_mysql.sql

Frank

[MHolkamp]

I tried, but still the same screen.
Any other idea's

Martin

[admin]

What value did you have in your app.ini for "locale"?

[MHolkamp]

locale = "en_US"

But KR is in dutch (half)
(I will take a look at the translation)