Gossamer Forum
Home : Products : Gossamer Links : Discussions :

links sql is no longer working

Quote Reply
links sql is no longer working
Quote | Reply link sql is no longer working
i'm getting this error when I click on any link in the directory

Links::Config (30755): Config file '/home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links/ConfigData.pm' did not return a hash reference. at /home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links.pm line 65.

and when i go to the admin area i get this error

Links::Config (815): Config file '/home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links/ConfigData.pm' did not return a hash reference. at /home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links.pm line 65.
Quote Reply
Re: [theguy] links sql is no longer working In reply to
the support tells me this now: does links sql need transactional InnoDB tables?

This is from your MySQL logs:

070429 10:33:31 mysqld started
Cannot initialize InnoDB as ''innodb_data_file_path'' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at

You have no support parameteres in /etc/my.cnf - If you use InnoDB you
should put them in there. Besides that MySQL is running:

[root@srv1 init.d]# ./mysqld status
mysql is running
[root@srv1 init.d]# ps axu | grep mysql
mysql 957 0.0 2.4 53880 12272 ? SN Apr29 1:42
/usr/libexec/mysq
mysql 961 0.0 2.4 53880 12272 ? SN Apr29 2:00
/usr/libexec/mysq
mysql 962 0.0 2.4 53880 12272 ? SN Apr29 0:04
/usr/libexec/mysq
mysql 971 0.0 2.4 53880 12272 ? SN Apr29 0:00
/usr/libexec/mysq
root 25025 0.0 0.1 1736 548 pts/1 R 18:14 0:00 grep
mysq
Quote Reply
Re: [theguy] links sql is no longer working In reply to
after i enable debugging i'm unable to access the admin area
is there a way to turn debugging off by telnet?
Quote Reply
Re: [theguy] links sql is no longer working In reply to
please someone help me here
Quote Reply
Re: [theguy] links sql is no longer working In reply to
theguy wrote:
Quote | Reply link sql is no longer working
i'm getting this error when I click on any link in the directory

Links::Config (30755): Config file '/home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links/ConfigData.pm' did not return a hash reference. at /home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links.pm line 65.

and when i go to the admin area i get this error

Links::Config (815): Config file '/home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links/ConfigData.pm' did not return a hash reference. at /home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links.pm line 65.
Hi,

Have you checked to see if /home/virtual/site1/fst/var/www/cgi-bin/search/admin/Links/ConfigData.pm has any content in it? I'm guessing this is a pre- LinksSQL 2.2, where the config file did have a habit of getting corrupt when certain things were done :(

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!
Quote Reply
Re: [Andy] links sql is no longer working In reply to
ConfigData.pm is an empty file
Quote Reply
Re: [theguy] links sql is no longer working In reply to
Hi,

Mmm.. do you have any backups? Thats definitely your problem (version 2.2.x+ have a method of making a .bak file in case of problems like you are experiencing).

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!
Quote Reply
Re: [Andy] links sql is no longer working In reply to
yes i have a back up to the database, does restoring the backup will solve all problems?
Quote Reply
Re: [theguy] links sql is no longer working In reply to
Hi,

I actually meant do you have a backup of the ConfigData.pm file :)

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!
Quote Reply
Re: [Andy] links sql is no longer working In reply to
i'm afraid i don't, what can i do now
all data is lost now?
Quote Reply
Re: [theguy] links sql is no longer working In reply to
What happens if you resync your database (better check with Andy or GT before trying this).
Quote Reply
Re: [theguy] links sql is no longer working In reply to
Hi,

If you have a ConfigData.pm backup somewhere (or can get hold of a "basic" version), then it could be possible to modify it manually to fit your setup.

I could do this for you, but it wouldn't be free - as its quite a bit of work. Please PM me if you want this done.

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!
Quote Reply
Re: [Andy] links sql is no longer working In reply to
thanks andy, i did find a backup copy of ConfigData.pm
all i need is upload it to the server and links sql would work again?
Quote Reply
Re: [theguy] links sql is no longer working In reply to
theguy wrote:
thanks andy, i did find a backup copy of ConfigData.pm
all i need is upload it to the server and links sql would work again?
Hi,

Cool. Yeah - it should work then. You may need to make some changes (i.e if you've changed things since then, i.e build paths, etc) .. but other than that, it should work fine.

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!