http://www.gossamer-threads.com/forum/ en-us gforum@gossamer-threads.com Sun, 19 May 2013 18:27:13 GMT Gossamer Forum by Gossamer Threads, Inc. http://www.rssboard.org/rss-specification http://static.gossamer-threads.com/forum/images/gforum-logo.png http://www.gossamer-threads.com/forum/ 50 50 http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bbrewt%5D_problems_after_moving_to_new_host_P309910/?page=unread#309910 Thanks, it seems like that might have done the trick. Still a hiccup here and there to iron out, but it appears that Links SQL 2.1 has been salvaged and will survive the move intact! Dan e7626ada49c76d517f69669d2119e3b5 Oct 21, 2010, 1:04 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309900/?page=unread#309900 That patches the adodb.inc.php file in the adodb directory. Adrian c824b9a9c90e08ce6fd2330219072f53 Oct 17, 2010, 3:18 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bbrewt%5D_problems_after_moving_to_new_host_P309897/?page=unread#309897 How would that get tied in? Does it get added to one of the files or placed in a new adodb.inc.php.patch file? If the latter, does adodb automatically know to load it if present? Dan 646d9441f348548bf0d04118172a4855 Oct 15, 2010, 10:08 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309893/?page=unread#309893 It's a simple patch: Code: --- adodb.inc.php.old Mon Sep 9 00:45:06 2002 +++ adodb.inc.php Mon Sep 9 00:45:28 2002 @@ -2118,7 +2118,7 @@ $this->bind = array(); for ($i=0; $i < $this->_numOfFields; $i++) { $o = $this->FetchField($i); - $this->bind[($upper) ? strtoupper($o->name) : strtolower($o->name)] = $i; + $this->bind[($upper) ? strtoupper($o->name) : $o->name] = $i; } } Adrian 9c24a71412c66e503f42e792e9127bb8 Oct 14, 2010, 11:55 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309892/?page=unread#309892 Hmm, I may have come up with a simple solution to the adodb warnings ... just copy the v5 function from adodb-mysql.inc.php over to the v2 function of the same name! There's a couple other spots that produce the same warnings (just in lesser numbers), so I'll have to go through and try swapping out more functions. If you have any further suggestions for tying in the v5 adodb altogether, I'm all ears. Dan af94fa2bb3b1f1e8d0e5b913b1df6a33 Oct 14, 2010, 9:09 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309891/?page=unread#309891 I solved the fatal error in Jump.inc.php and Rate.inc.php! In both cases, $sth was returning false and needed an if() check in order to successfully execute fetchrow_one(), i.e.: Code: if ($sth) { $rows = $sth->fetchrow_one(); } I'm not sure if that's a PHP or MySQL difference resulting in the false return value... I'll have to do more interface testing to see if the problem exists in any of these other files that contain fetchrow_one(): Add.inc.php, Authenticate.inc.php, Modify.inc.php, Page.inc.php, Review.inc.php, Search.inc.php, Subscribe.inc.php, Utils.inc.php, User.inc.php That's a major issue checked off the list! Now if I can just figure out the adodb piece and clean up all those error log warnings... Dan b32bdbb9a3dc354a9bbf41be0b820fad Oct 14, 2010, 8:59 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bbrewt%5D_problems_after_moving_to_new_host_P309890/?page=unread#309890 Quote: There's a patch in the admin/Links/PHP/adodb directory adodb.inc.php.patch I don't see any such file in the old or new versions of adodb... Are you sure it's in there by default? Dan ac08f04cf2d45929f7a18184f4e35124 Oct 14, 2010, 7:30 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309889/?page=unread#309889 I believe there is one thing that you do need to do to get ADOdb working. There's a patch in the admin/Links/PHP/adodb directory adodb.inc.php.patch, though I doubt it patches cleanly. The patch just turns off forcing upper/lower case of the column names. Note that the adodb that LinksSQL came with was 2.40 released in Sept 2002! It's now at 5.11, so I'm not sure if they kept compatibility all that time. You might need to read through the changelogs: http://phplens.com/adodb/change.log.html http://phplens.com/adodb/old-changelog.htm For the fatal errors, I think you need to figure out why the $DB object isn't set. fetchrow_one() is defined in SQL.inc.php and is essentially the same thing as a fetchrow(). Adrian 275958e8fb4b2dd11f5a821c74b56f1c Oct 14, 2010, 7:22 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bbrewt%5D_problems_after_moving_to_new_host_P309888/?page=unread#309888 Quote: Since it's an error with ADOdb, one thing you might try is to upgrade ADOdb: Thanks, that seems worth a try. Getting rid of all those error log warnings would be nice! Only problem is, that broke everything. Blank category listings and error pages, with the logs filled up with stuff like: PHP Notice: Undefined index: ID in /.../cgi-bin/links/admin/Links/PHP/Utils.inc.php on line 164 PHP Notice: Undefined index: Name in /.../cgi-bin/links/admin/Links/PHP/Utils.inc.php on line 166 Is there anything that needs to be done to tie in an upgraded ADOdb? I ran one of the recommended test scripts and ADOdb itself is working. As for the fetchrow_one() fatal error in Jump.inc.php, I found the same thing happens when rating a link: PHP Fatal error: Call to a member function fetchrow_one() on a non-object in /.../cgi-bin/links/admin/Links/PHP/Rate.inc.php on line 82 I haven't seen that happen with any of the other fetch* functions, so it appears to be specific to the fetchrow_one() behavior. I tried tweaking a few things with $this->$row type assignments but had no luck... Dan 53e8597bc1be0f7ba19fc8ba106693fc Oct 14, 2010, 6:58 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309887/?page=unread#309887 Since it's an error with ADOdb, one thing you might try is to upgrade ADOdb: http://adodb.sourceforge.net/ Adrian d98353339618da92e864d27c8216c3c3 Oct 14, 2010, 4:06 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BAndy%5D_problems_after_moving_to_new_host_P309886/?page=unread#309886 Well, no luck with the reinstall. Same error and warnings as before. It seems to be specific to the PHP files. I'm not getting errors with the CGI scripts, such as accessing jump.cgi directly. As far as I can tell, the problem is with the PHP code. Perhaps something deprecated in newer versions like the login problem I had earlier this year? From the linked release announcement: Quote: The PHP front-end is no longer supported due to miniscule usage by client base. Weird. Any idea what that assumption was based on? I know I was never surveyed... In looking for solutions to these host migration problems, I've seen lots of comments on various forums about abandoning Links because of the discontinued PHP front end support, with the majority of dynamic sites being PHP-driven and not using Perl anymore. I'm hoping I don't have to resort to that, but it's a very real possibility. Resorting to mod_rewrite might work but isn't available to everyone and generally comes with a heavy word of caution... Dan c8d7170478483f8ffed19c726efc37b1 Oct 14, 2010, 12:19 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309885/?page=unread#309885 Hi, Ok cool :) Re why the PHP was removed - not sure there is a major reason - but found this: http://www.gossamer-threads.com/.../?page=unread#unread Quote: The PHP front-end is no longer supported due to miniscule usage by client base. To be honest, most stuff you wanna do with PHP can be done just as easily using globals + mod_rewrite .... I posted quite a few threads about how this can be done - for example: Code: sub { return system("php /path/to/run/script.pm"); } ...and this retuns the content of what that script outputted I never really got on with the PHP system - was too "different" to the Perl version - and also had quite a few limits, such as plugins not be usable, globals not working, etc .... which is why I never really got into it at all =) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 3520e283f6e39b5bfd1468943b0d6499 Oct 14, 2010, 9:30 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BAndy%5D_problems_after_moving_to_new_host_P309884/?page=unread#309884 Gotcha, thanks. Probably easier to use EditPlus to check the files locally... Sure enough, there are a few that didn't get updated! I'll probably have to reinstall after an attempted v3.3 upgrade to that folder, so it'll be a bit before I know if that was the full problem... Is there a publicly available reason why development was abandoned on the PHP front end? It seemed like a very popular option at the time, but people must have lost interest somewhere along the line, either developers or users. Dan 30f9b4f8239b29d3e714973e91a7ba85 Oct 14, 2010, 9:15 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309883/?page=unread#309883 Hi, Are you on a UNIX server? If so, login via SSH/Telnet, and run: Code: grep -r -l 'old_db_name' . (the . at the end is important :)) Then see if it comes up with any files (depending how large your site is, it may take a while to run this command) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates edaf39b65f8627e49752300d2a6ba8b7 Oct 14, 2010, 9:00 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BAndy%5D_problems_after_moving_to_new_host_P309882/?page=unread#309882 Andy wrote: Maybe try doing a "grep" in SSH for your OLD DB details, and see if any other files come up with it? Could you be more specific? I don't quite know what that means to do or what I would be looking for. Dan a1dc1914798b35f1be1a4fc66cf7b77b Oct 14, 2010, 8:54 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BDan_Kaplan%5D_problems_after_moving_to_new_host_P309881/?page=unread#309881 Hi, Mmm.. it *almost* sounds like an issue with the DB connection - but seems weird that it would work for most of the other stuff, but not the Jump etc I havn't used the PHP file for ages. From memory, I think there was a new "connection" system in the PHP scripts .... Maybe try doing a "grep" in SSH for your OLD DB details, and see if any other files come up with it? Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 83f1cb47a6ea5bdc05478068a2f7bcd1 Oct 14, 2010, 1:07 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/problems_after_moving_to_new_host_P309878/?page=unread#309878 I realize the PHP front end is no longer being supported (a true shame), but hopefully these errors and warnings ring a bell for someone. I couldn't find anything relevant in old posts. After transferring the site to a new host, most stuff appears to be functioning correctly. One problem is this error log warning every time a page is loaded: Only variable references should be returned by reference in /.../cgi-bin/links/admin/Links/PHP/adodb/drivers/adodb-mysql.inc.php on line 423 The bigger problem I discovered is the Jump links don't work. PHP Fatal error: Call to a member function fetchrow_one() on a non-object in /.../cgi-bin/links/admin/Links/PHP/Jump.inc.php on line 120 Any ideas? I'd much prefer salvaging the old install rather than upgrade to the new one, if at all possible. Integrating a CGI script into a PHP site and templates is never fun. Dan 619b5e0e8c68fa4307edf591f74af02a Oct 13, 2010, 8:53 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5BAndy%5D_Question_for_whoever_wrote_the_PHP_front_end%3F_P303064/?page=unread#303064 Kinda sad I guess. Perl is out the door these days and no-one hardly ever programmes in it anymore. If links is to survive it will have to be done in php in the near future. my 2 cents as I only ever use php now - wont touch cgi. 4751c981163370c7a7ee895d938bd1f4 Aug 3, 2008, 4:27 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bbrewt%5D_Question_for_whoever_wrote_the_PHP_front_end%3F_P302635/?page=unread#302635 brewt wrote: Sorry, I can't help... it's just been so many years since I've touched PHP. haha - join the club <G> 8ec1f0c3272681404e7cc025013f04ce Jul 1, 2008, 5:46 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/PHP_Front_End_F27/Re%3A_%5Bryel01%5D_Question_for_whoever_wrote_the_PHP_front_end%3F_P302633/?page=unread#302633 Sorry, I can't help... it's just been so many years since I've touched PHP. Adrian cfa86d5dc3270e784da7ed6c3101e2bd Jul 1, 2008, 4:53 AM