Gossamer Forum
Home : Products : Gossamer Links : Discussions :

lsql_SearchLog.def?

Quote Reply
lsql_SearchLog.def?
I tried to restore data in Admin-database-import/export-restore data. Then I got an fatal error about lsql_SearchLog.def does not exit or permissions are not right...

I set all my Links directory to be 777. So I think that it may not be a permission problem. But I did not find lsql_SearchLog.def in .../Links/admin/defs directory. What is this file and how do I get it? Help, somebody
Quote Reply
Re: [banana] lsql_SearchLog.def? In reply to
go to the admin->setup->SQL area, and pick the LAST option, to recreate the .def files, but *NOT* overwrite any data, or make new tables.

That should fix it.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [banana] lsql_SearchLog.def? In reply to
You need to reinstall the SearchLogger plugin before you reinstall data.

When the backup was made, the plugin was installed, and the backup also stored the SearchLog information in that table.

Once you reinstalled your data, you can delete the SearchLogger plugin again, and then make a new backup. In that way you will be able to reinstall data in the future without the error you are getting now.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Your instructions fixed my problem In reply to
 
Quote Reply
Re: [banana] Your instructions fixed my problem In reply to
Sorry to bring back this thread.

I got this error while clicking on 'Dynamic' link in top menubar: 'fatal error about lsql_SearchLog.def does not exit or permissions are not right...'

I reinstalled 'Searchlogger' plugin' > I selected the 'Load table info from an existing set of tables (or resync the def files if you have changed your defs manually).' under 'SQL server' > saved.


Now I got this error:
-----------------------
Results:
Users .. ok!
Links .. ok!
Changes .. ok!
Category .. ok!
CatPrice .. ok!
Reviews .. ok!
CatLinks .. ok!
CatRelations .. ok!
Editors .. ok!
Verify .. ok!
Sessions .. ok!
EmailTemplates .. ok!
EmailMailings .. ok!
MailingIndex .. ok!
MailingList .. ok!
MailingListIndex .. ok!
ClickTrack .. failed: Failed to execute query: 'DESCRIBE lsql_ClickTrack': Table 'webmaste_resources.lsql_ClickTrack' doesn't exist
Payments .. ok!
PaymentLogs .. ok!
Bookmark_Folders .. ok!
Bookmark_Links .. ok!
SearchLogs .. ok!
NewsletterSubscription .. ok!
------------------

Hoew to remove this error?

thanks.
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Hi,

It looks like your ClickTrack table doesn't exists. Can you see it in MySQLMan ?

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] Your instructions fixed my problem In reply to
I am seeing 'lsql_ClickTrack_tmp' table.
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Hi,

Mmm.. do you see a lsql_ClickTrack.def file in /admin/def ?

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] Your instructions fixed my problem In reply to
Yes. I am seeing 'lsql_ClickTrack.def' file.
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Please delete that, then try doing the table re-sync again (as you did above)

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] Your instructions fixed my problem In reply to
Now there is no lsql_ClickTrack.def file in /def/ directory.

But still error -

.........
ClickTrack .. failed: Failed to execute query: 'DESCRIBE lsql_ClickTrack': Table 'webmaste_resources.lsql_ClickTrack' doesn't exist
...........
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Please send over GLinks admin details, and FTP access - and I'll take a look for you. Very hard to really see whats going on without that =)

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: [hegu] Your instructions fixed my problem In reply to
Hi,

Thanks, got the info.

It seemed to work ok for me (the "re-sync")

Creating Users table... failed (table already exists)
Creating Links table... failed (table already exists)
Creating Changes table... failed (table already exists)
Creating Category table... failed (table already exists)
Creating Category tree... failed (A tree already exists for table 'lsql_Category')
Creating CatPrice table... failed (table already exists)
Creating Reviews table... failed (table already exists)
Creating CatLinks table... failed (table already exists)
Creating CatRelations table... failed (table already exists)
Creating Editors table... failed (table already exists)
Creating Verify table... failed (table already exists)
Creating Sessions table... failed (table already exists)
Creating EmailTemplates table... failed (table already exists)
Creating EmailMailings table... failed (table already exists)
Creating MailingIndex table... failed (table already exists)
Creating MailingList table... failed (table already exists)
Creating MailingListIndex table... failed (table already exists)
Creating ClickTrack table... okay
Creating Payments table... failed (table already exists)
Creating PaymentLogs table... failed (table already exists)
Creating Bookmark_Folders table... failed (table already exists)
Creating Bookmark_Links table... failed (table already exists)
Creating SearchLogs table... failed (table already exists)
Creating NewsletterSubscription table... failed (table already exists)

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] Your instructions fixed my problem In reply to
PM sent.

thanks
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Thank you very much Andy! I am seeing lsql_ClickTrack table now :)
Quote Reply
Re: [hegu] Your instructions fixed my problem In reply to
Hi,

No problem. I also noticed dynamic is working fine for you now too :)

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!