Problem upgrading from 0.9.8.6rc1 to 0.9.9rc1

[eeephreakeee]

Hello,
I am not sure what I have done wrong. I followed the upgrade instructions exactly. I get the errors below after copying everything over browsing to the index. If I switch back to 0.9.8.6rc1 everything is fine.

2009-04-24 14:50:46] [ERROR]: ERROR IN QUERY: "SELECT * FROM access WHERE table_name='tree' AND belongs_to=16"
[2009-04-24 14:50:46] [BACKTRACK]: 1146:1146

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/share/knowledgeroot/include/class-mysql.php on line 113
[2009-04-24 14:50:46] [ERROR]: ERROR IN QUERY: "SELECT * FROM access WHERE table_name='tree' AND belongs_to=51"
[2009-04-24 14:50:46] [BACKTRACK]: 1146:1146

Thanks,
Jason

[admin]

Hi,

yes. This is right and a bug. This fixed in rc2.
Problem was that i have forgot to add the dump for this

Frank

[eeephreakeee]

Thanks Frank. I was going crazy trying to figure out what I did wrong. When will rc2 be available for download?

Thanks,
Jason

[admin]

Hi,

i have no timetable for this. I will do my best to release this as fast as possible.
The open tasks for rc2 can you find here:
http://trac.knowledgeroot.org/cgi-bin/trac.cgi/query?status=new&status=assigned&status=reopened&milestone=0.9.9

If you cannot wait. You could also use the svn version. You only need to make a checkout

Frank

[eeephreakeee]

Hi Frank,
what am I doing wrong? I see everyone else is upgrading with almost no issues to 0.9.9.1 stable, however. When I try to upgrade from 0.9.8.6rc1 to 0.9.9.1 I am still getting the same errors as above.

Thanks,
Jason

[admin]

Hi,

what errors did you become? Only SQL errors with table access or some more?

I tested a upgrade from 0.9.8.6rc1 to 0.9.9.1. I only found a problem with user creation that i need to check.

Frank

[eeephreakeee]

I get the same sql errors as above.

Are the upgrade instructions that come with the package still valid? All I have to do is copy over the config and uploads folder?

[admin]

Hi,

i need some more informations:
Windows/Linux?
Which versions of apache/php/mysql?
Could you make a dump of the database for me?
I need the exact version of the knowledgeroot version for update and the version of knowledgeroot you want to update.

Frank

[eeephreakeee]

Linux
Apache: 2.2.8
MySQL: 5.0.51
PHP: 5.2.4-2
Current Knowledgeroot version: 0.9.8.5
Attempting to upgrade to: 0.9.9.1

I am sorry, I just realized I have been telling you the wrong version. I am on 0.9.8.5 =|. The upgrade document says the upgrade steps should be the same though.

[admin]

Hi,

i have made a first test and have not the same result as you.
A database Dump would be fine with the structure of your database. I do not need the content.
Did you make a update to 0.9.8.5 from a previous version?
Could you make a screenshot with the error?

Frank

[eeephreakeee]

Hi Frank,
I have emailed you the database structure dump and the screen shot. I did not upgrade from another version, I started with 0.9.8.5.

Thanks,
Jason