Posted on: 05/25/05 07:09pm
By: Sonnyb
I saw some stuff in the Dev forum about adding trackback and ping functions to the GL 1.3 code branch, thanks guys I was just going to ask for it.
I assume that means I need to run a CVS update to get it working. Anyone else out there using it? Any issues or gotchas? I'n not terribly familiar with CVS itself, used it once or twice for other stuff and I saw the CVS link with the commands. Other than backing up my database do I need anything else?
Implementing trackback/pingback
Posted on: 05/25/05 11:22pm
By: Sonnyb
Hmmm, I discovered that a 1.3.12 upgrade via CVS over a non-CVS 1.3.11 install is very very bad. I think it was because I tried a CVS upgrade before then backed it out. It made db changes that are still there I guess.
I got sql errors trying to upgrade the db. Mostly it was complaining that tables already existed. I tried removing the offending tables, then it gave me an error about the contents of a table. After many, many table dumps and table creations and imports in my new best friend phpmyadmin, I despaired and restored 1.3.11.
It hates me.
No trackback for me.
Bedtime for me....
Implementing trackback/pingback
Posted on: 05/26/05 12:30pm
By: Dirk
Well, CVS is in a bit of a rough state at the moment, so it's certainly not for the faint at heart.
Apart from an SQL error in the upgrade procedure (that I just fixed) and the fact that you get a "Your account has been banned" message instead of the success message, it should work, though.
Just treat this as a normal upgrade: Install all of the new files, run the install script in upgrade mode - and that should be it.
bye, Dirk
Implementing trackback/pingback
Posted on: 05/26/05 01:04pm
By: Sonnyb
Just treat this as a normal upgrade: Install all of the new files, run the install script in upgrade mode - and that should be it.
Does that mean I should run CVS from another directory then move the results over to my current geeklog and public_html directories? I'm getting nervous because it reduced my site to pile of smoking electrons last night. I have nightly backups for major disaters and GL SQL backups, done immediately before, for minor boo-boos. Just in case...
Implementing trackback/pingback
Posted on: 05/26/05 01:56pm
By: Dirk
[QUOTE BY= Sonnyb] I'm getting nervous because it reduced my site to pile of smoking electrons last night.[/QUOTE]
In that case you shouldn't really be running CVS code on a "live" site. It is under heavy development at the moment and contains lots of rough edges.
bye, Dirk
Implementing trackback/pingback
Posted on: 05/27/05 01:05am
By: Sonnyb
Since I got tired of restoring from backup (u gotta love a recent backup), I'm trying out the latest CVS version on a test site. Fresh db and db user. I do the new install, after I get the completion message and get in the site and login with the admin user I get blank pages with a short msg about an SQL error and instruction to check the error.log:
Fri May 27 00:46:17 2005 - 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 ','','','','','',0,'',1,,,,,,)' at line 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,related,date,commentcode,postmode,frontpage,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon) VALUES (,,'','','','','',0,'',1,,,,,,)
Is this the correct forum for hot and fresh CVS code errors?
CVS install issue
Posted on: 05/28/05 06:46pm
By: Sonnyb
Anyone have any thoughts on this?
Implementing trackback/pingback
Posted on: 05/28/05 07:37pm
By: Turner
That error is not very informative. Since you are testing CVS, I'd just download the latest CVS version, being sure to also take the PEAR libraries, and then re-install from scratch.
Implementing trackback/pingback
Posted on: 05/28/05 10:01pm
By: Sonnyb
Thanks, the new nightly CVS got it to the main site page after the install. The PEAR upgrade got the trackback admin page working. I also had this error in my messages log:
open_basedir restriction in effect. File(/usr/share/pear/XML/RPC.php) is not within the allowed path(s)
Which I resolved by adding /usr/share/pear/ to the open_basedir path. I'll play with it a bit then try it will the plugins I run and a copy of my production site databasae. This time it's looking a lot more stable this time around.
Implementing trackback/pingback
Posted on: 05/29/05 12:26am
By: Sonnyb
The install errors are gone but I can't upgrade the existing database. I created a fresh db then imported a backup copy of production data into the new empty db and attempted an upgrade. Too many SQL errors I don't know how to handle. Dirk was right about CVS code being rough. Too rough for me. I'm done with this until a stable release version of 1.3.12 comes out.
I think I'll take my frustrations out on a nice violent game of counterstrike.
C ya