Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 12:36 pm EDT

Geeklog Forums

phplinks-GL1.3.8 integration errors!!


Meng

Anonymous
Help!! I\'m just upgraded to GL1.3.8 and has been having problems with the phpLinks-1.3.8 update integration for days. Anyone has similar errors and can advise? 1) Everytime I try using the phplinks-1.3.8 lib-common file, I get this error: 1054: Unknown column \'perm_anon\' in \'where clause\' SQL in question: SELECT ID,SiteName,UNIX_TIMESTAMP(Added) AS day FROM gl_pllinks WHERE (perm_anon >= 2) ORDER BY id DESC LIMIT 15 2) Once I use the phplinks-1.3.8\'s stats.php, I get this error: 1054: Unknown column \'owner_id\' in \'where clause\' 3) Where can I get the installtion instructions for phplinks-1.3.8? I tried downloading the package again & still don\'t see any doc? I\'ve been lost for a few days, anyone can help?? Pls. Appreciate it. Thanks Meng
 Quote

Status: offline

squatty

Forum User
Full Member
Registered: 01/21/02
Posts: 269
There was a few bugs in the orginal release package. You can download the updated package here.
In a world without walls and fences, who needs Windows and Gates?
 Quote

Meng

Anonymous
Hi, Many thanks. Unfortunately still don\'t work, I just downloaded for 3rd time today to try but following error still occurs: 1054: Unknown column \'perm_anon\' in \'where clause\' SQL in question: SELECT ID,SiteName,UNIX_TIMESTAMP(Added) AS day FROM gl_pllinks WHERE (perm_anon >= 2) ORDER BY id DESC LIMIT 15 Could you advice me where this SQL is possibly called from or did I miss any changes that needs to be done in other files besides those downloaded? I\'ve totally lost...Pls advise? Thanks a million! Meng
 Quote

Status: offline

squatty

Forum User
Full Member
Registered: 01/21/02
Posts: 269
OK, I found the problem. The download package did not get updated correctly. I don\'t have access to do it today. The error is in lib-common. Make sure the SQL statement looks like this: $sql = \"SELECT ID,SiteName,UNIX_TIMESTAMP(Added) AS day FROM {$_TABLES[\'pllinks\']} ORDER BY id DESC LIMIT 15\"; You need to replace the above statement in two places in lib-common.php.
In a world without walls and fences, who needs Windows and Gates?
 Quote

Meng

Anonymous
Thanks. Problem is resolved, really appreciate your help and kindness. Meng p.s. really like your quote in yr signature on walls and fences! Damn cool!
 Quote

All times are EDT. The time is now 12:36 pm.

  • 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