Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Cant call method "table" on an undefined value at ...........

Jan 21, 2005, 4:18 AM
globus
Novice (11 posts)
Jan 21, 2005, 4:18 AM
Post #1 of 21
Views: 6658
Shortcut
Quote Reply
Cant call method "table" on an undefined value at ...........
Hi
I was trying to move the Links SQL site to a new server. I successfully exported the whole database to the new site and also copied all the files. But when I am trying to run the cgi files,they throw errors
I get this when I call jump.cgi


A fatal error has occured:
Can't call method "table" on an undefined value at /home/moniker/www/cgi/admin/Links/User/Jump.pm line 30.

Please enable debugging in setup for more details.


Line 30 in Jumps.pm is
my $db = $DB->table('Links');

Also, can anyone tell me the steps to move a Links SQL site to a new server. I think I forgot to change any settings in configuratoin file?
Globus

Jan 21, 2005, 7:11 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 7:11 AM
Post #2 of 21
Views: 6380
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Are your use lib '' paths correct?

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 7:35 AM
globus
Novice (11 posts)
Jan 21, 2005, 7:35 AM
Post #3 of 21
Views: 6315
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
Hi Andy
I think so but still please tell me which files to check for the libs path and I will set them correct. There are so many files that I dont know which files to check.
Also, do you have any idea when I click on the link which calls a cgi file like jump.cgi?ID=23235 the database is read. Now where is this db username/password info stored so that I can change the setttings
Thanks much
Globus
Jan 21, 2005, 7:39 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 7:39 AM
Post #4 of 21
Views: 6398
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Hi,

The use lib '' lines are in pretty much all the .cgi files, as well as a few of the .pm ones.

You can get a quick list by running this command in SSH/Telnet;

grep -r -l '/your/old/path/to/admin' .

... and that should give you a list of file.

Regarding the DB settings, these are in /admin/defs/database.def.

Hope that helps Smile

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 8:10 AM
globus
Novice (11 posts)
Jan 21, 2005, 8:10 AM
Post #5 of 21
Views: 6349
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
In Reply To:
Hi,

The use lib '' lines are in pretty much all the .cgi files, as well as a few of the .pm ones.

You can get a quick list by running this command in SSH/Telnet;

grep -r -l '/your/old/path/to/admin' .

... and that should give you a list of file.

Regarding the DB settings, these are in /admin/defs/database.def.

Hope that helps Smile

Thanks for the reply
I have changed the db settings in database.def but I am still getting the same errors as above

Globus
Jan 21, 2005, 8:20 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 8:20 AM
Post #6 of 21
Views: 6353
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Mmm.. in Setup > Misc, turn "debug" onto "Debugging enabled" .. and then run the page again. Do you get any more interesting debug info, in regards to MySQL? (should give an error about connecting, or the actual MySQL error).

Hope that helps.

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 8:24 AM
globus
Novice (11 posts)
Jan 21, 2005, 8:24 AM
Post #7 of 21
Views: 6323
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
In Setup > Misc.......

Sorry but which Setup you are talking about?
Globus
Jan 21, 2005, 8:30 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 8:30 AM
Post #8 of 21
Views: 6346
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
In your admin panel... http://www.yoursite.com/cgi-bin/links/admin/admin.cgi :)

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 8:34 AM
globus
Novice (11 posts)
Jan 21, 2005, 8:34 AM
Post #9 of 21
Views: 6335
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
After changing the paths in cgi files and making sure the permission is 755, I am now getting the classic error

---------------------
Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, root@localhost.localdomain and inform them of the time the error occurred, and anything you might have done that may have caused the error.
----------------------------
Server logs say the same thing:
Premature end of script headers: /moniker/public_html/cgi/jump.cgi
Jan 21, 2005, 8:48 AM
globus
Novice (11 posts)
Jan 21, 2005, 8:48 AM
Post #10 of 21
Views: 6340
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
In Reply To:
In your admin panel... http://www.yoursite.com/cgi-bin/links/admin/admin.cgi :)

Cheers
Funny but Same errror when I am calling the admin.cgi
-----------------------------------------------------
Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, root@localhost.localdomain and inform them of the time the error occurred, and anything you might have done that may have caused the error.
--------------------
Jan 21, 2005, 8:59 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 8:59 AM
Post #11 of 21
Views: 6324
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
You sure /moniker/public_html/cgi/ is your path? It doesn't look right to me.

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 9:05 AM
globus
Novice (11 posts)
Jan 21, 2005, 9:05 AM
Post #12 of 21
Views: 6380
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
I wrote that in a rush
The exact error is
Premature end of script headers: /home/moniker/public_html/admin/admin.cgi
when calling admin
and
Premature end of script headers: /home/moniker/public_html/cgi/jump.cgi
when calling jump.cgi
Jan 21, 2005, 9:07 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 9:07 AM
Post #13 of 21
Views: 6413
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Does you're Perl error log show anything?

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 9:09 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 21, 2005, 9:09 AM
Post #14 of 21
Views: 6375
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Ah, one thing to check ... are the folders CHMOD 777, or 755? If they are 777, then you may want to try iton 755, and see how that works.

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 21, 2005, 9:17 AM
globus
Novice (11 posts)
Jan 21, 2005, 9:17 AM
Post #15 of 21
Views: 6360
Shortcut
Quote Reply
Re: [Andy] Cant call method "table" on an undefined value at ........... In reply to
All folders are 755
I guess I have to overwrite everything again and try?
May I ask referring to my original post again that what are the necessary steps and precautions to be taken while moving the Links SQL site. Any readme as I have lost the Readme which was provided. Also does it matters I opened the cgi files in wordpad and changed the paths and I have heard there is some ascii format restriction
Many thanks
Jan 21, 2005, 2:21 PM
globus
Novice (11 posts)
Jan 21, 2005, 2:21 PM
Post #16 of 21
Views: 6309
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Anything Andy?
Jan 21, 2005, 2:45 PM
brewt
Staff (4101 posts)
brewt's avatar
Jan 21, 2005, 2:45 PM
Post #17 of 21
Views: 6467
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Have you checked that your database login/prefix/etc info?

Adrian
Jan 21, 2005, 9:21 PM
globus
Novice (11 posts)
Jan 21, 2005, 9:21 PM
Post #18 of 21
Views: 6341
Shortcut
Quote Reply
Re: [brewt] Cant call method "table" on an undefined value at ........... In reply to
Have you checked that your database login/prefix/etc info?
As far as I think I did but let me know which all files to check for
Thanks
Jan 22, 2005, 12:34 AM
brewt
Staff (4101 posts)
brewt's avatar
Jan 22, 2005, 12:34 AM
Post #19 of 21
Views: 6310
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Check all the info in the admin => Setup => SQL Server. Select the default of " Create new default Links SQL tables in this database but do not overwrite any existing data." (the first option), and press Submit. You shouldn't get any fatal errors (just table already exists warnings).

Adrian
Jan 22, 2005, 1:12 AM
globus
Novice (11 posts)
Jan 22, 2005, 1:12 AM
Post #20 of 21
Views: 6326
Shortcut
Quote Reply
Re: [brewt] Cant call method "table" on an undefined value at ........... In reply to
In Reply To:
Check all the info in the admin => Setup => SQL Server. Select the default of " Create new default Links SQL tables in this database but do not overwrite any existing data." (the first option), and press Submit. You shouldn't get any fatal errors (just table already exists warnings).
As I already said above admin.cgi is giving errors
Jan 23, 2005, 7:05 PM
jdgamble
Enthusiast (700 posts)
jdgamble's avatar
Jan 23, 2005, 7:05 PM
Post #21 of 21
Views: 6268
Shortcut
Quote Reply
Re: [globus] Cant call method "table" on an undefined value at ........... In reply to
Check your cgi-bin/admin/Links/Config/data.pm file for path errors. If that doesn't work I suggest you back-up your templates and globals.txt and reinstall links (You shouldn't have to change your sql db at all).

Good Luck!

- Jonathan