Geeklog Forums

I'm having some GL139 upgrade issues, and was hoping someone might be able to help. I've searched here on gl.net, but haven't found anything too useful.

Here's what I'm trying to do, and what's happening ... I'm trying to "test upgrade" my GL137sr2 database to GL139 before I do it for real on the server. So on my OS X machine, I've created a new GL139 directory structure, and placed all the new GL139 files in the right spots (no legacy stuff from my site, just new files). config.php and lib-common.php are edited correctly, and all files can be found, etc.

On the MySQL side, I created a new blank "gl139test" database. Then I mysqldumped my live data, and imported it to the test database. So far so good. So now I'm technically ready to run the upgrade-install in GL139. I do that, specify the path, set it to upgrade, etc.

Problem #1: The system comes back and tells me "Table gl139test.staticpage does not exist." This is true; I don't have the staticpage table on the main site (never used it, so I never installed it, and prior upgrades never added it).

Thinking I can outsmart the installer, I open the SQL file for the GL139 clean install (in the SQL folder), and find the staticpage table definition. A quick copy/paste later, and I now have a staticpage table. So I quit and restart the installer, again in upgrade mode, etc. etc. etc.

Problem #2: Now the installer comes back and says "Duplicate column sp_inblock in gl139test.staticpage. Grrr, highly frustrating. So I try to help it again, and delete that column from the staticpage table. I rerun the installer, etc. and now ... it seems to work! I get the success page, and it shows the NewAdmin account message, etc.

Problem #3: When I attempt to login with NewAdmin, I get an SQL error. Digging in the logs, I see this:

"Fri Mar 19 17:41:24 2004 - 1054: Unknown column 'pwrequestid' in 'field list'. SQL in question: UPDATE users SET pwrequestid = 'NULL' WHERE username = 'NewAdmin'"

I look, and sure enough, there's no pwrequestid field. So I copy/paste from the SQL master file to create it, and then try to login again. This time, in the error log, I get:

"Fri Mar 19 17:45:28 2004 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near” at line 1. SQL in question: DELETE FROM sessions WHERE uid ="

And this is where I'm stuck. I've dropped and re-imported the database at least five times now, and I don't know what else to try. I've search geeklog.net, and the only instances of "pwrequestid" I found was one where you replied that it was a problem with the way the user ran the installer. Now I've installed Geeklog probably 100 times over the years, so I think I understand the process and I don't think I'm screwing up (but that's why I provided all this detail, in case you see something I missed).

Any thoughts on (a) what's going wrong, and (b) (more impportant) how I can get through the installer? I know it's not a register_globals problem, as this is the same box I use to post the hints in GL137sr2 every morning...

thanks;
-rob.

I did several 1.3.7 to 1.3.9 upgrades this week. I removed all the Geeklog 1.3.7 files, restored the 1.3.9 archive then updated the config and lib-common. It references my 1.3.7 database - run the install and choose upgrade.

I was then able to bring up my 1.3.9 site.

Next step was to upgrade some plugins but I did not have any staticspages on the 3 sites I upgraded.

---

Geeklog components by PortalParts -- www.portalparts.com

Yep, that's basically exactly what I did (the only difference being I first exported my data set on one machine and imported it on another). No go, and I think it's all related to the lack of the staticpage table -- did your 1.3.7 sites have that table already?

If so, can you tell me what fields it contained?

thx;
-rob.

Text delted; email reply received (thanks Dirk!).

-rob.

See my reply on geeklog-users.

bye, Dirk