Geeklog Forums

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

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?

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

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?

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!