Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 10:41 am EDT

Geeklog Forums

Implementing trackback/pingback


Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
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.
Big Celebration

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?
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
sleepy
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. Banging your head
Bedtime for me....
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
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... praying it will work
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Sonnyb: I'm getting nervous because it reduced my site to pile of smoking electrons last night.

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
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
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:
Text Formatted Code
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?
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
Anyone have any thoughts on this?
 Quote

Status: offline

Turner

Forum User
Chatty
Registered: 04/11/05
Posts: 42
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.
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
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:
Text Formatted Code
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.
 Quote

Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
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
 Quote

All times are EDT. The time is now 10:41 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content