Gossamer Forum
Home : Products : Gossamer Links : Discussions :

[BUG] ?? Can't do build via ssh

Quote Reply
[BUG] ?? Can't do build via ssh
I am logged in via ssh client and am trying to do build all, however am getting an error. Also, I am able to do build all via admin interface, but not via ssh : Please help:


Attached is the error file.

Vishal
-------------------------------------------------------

Last edited by:

SWDevil.Com: Jul 29, 2009, 11:44 PM
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
All right, I take it back, it does not even seem to do 'complete build' even when done via admin interface.

It does build detailed pages, however does nothing for category pages and simply shows

Code:
Building HTML Pages: Building Detailed Pages: Page 25 of 84

Building HTML Pages: Building Detailed Pages: Page 25 of 84

Gossamer Links is now updating your detailed pages.

Started at Thu Jul 30 02:52:33 2009.

Building Detailed pages...

Done (0.11s)

All done. Total time: (151.25s)
And moves on to next page with similar results.. :(

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
Hi Vishal,

I don´t get it. Can you please give some more details. Does the site work in dynamic mode? Is there an error message.
It looks like you are giving the debug output or is the "protocol-output" your error.
Did you try to execute the the SQL Commands in the MySQL-Monitor?

Regards

Niko
Quote Reply
Re: [el noe] [BUG] ?? Can't do build via ssh In reply to
I have never really used mysql monitor. (don't have any clue on how mysql query works)

1. Yeah the site is working just fine in dynamic mode
2. Error happens 100% of times when I try to do build via ssh (however I did notice it does finish building homepage and then gives the error)
3. When I try doing build via admin interface, it works fine for Build Staggered, however it only does detailed pages and when it comes to building categories pages it simply reload pages as mentioned above.

Vishal
-------------------------------------------------------

Last edited by:

SWDevil.Com: Jul 31, 2009, 11:40 AM
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
There is nothing special about it, I use it for debugging or testing. If you are not familiar with SQL commands I recommend that you only check your select statements.
So you could go to Database -> SQL Monitor and enter from your output e.g.:

Code:
SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID...

And see what it returns. If you have not changed any field properties of your Database manually or by a Plugin I see no reason for your problems.
I think there is still some information missing or I don´t see the wood for the trees.
I suggest:
- check the SQL Statements and see if there are results
- uninstall the plugins one by one (only if you do not lose any data you added after an installation) and recheck every time if the error stops to see if there is a problem with a plugin
- post if there is any more information

If someone of GT would take a look at your installation it would probably take some minutes.

Regards

Niko
Quote Reply
Re: [el noe] [BUG] ?? Can't do build via ssh In reply to
I just used that command in sql monitor and it is giving an error
Error: Could not execute query: Failed to execute query: 'SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID': Unknown table 'lsql_Links'

Not sure why it would say that as I am able to see that table via phpmyadmin.

I am gonna uninstall plugins one and one and see if anything helps.

Yeah I am waiting to hear from GT team.. generally they are pretty quick & good at taking care of issues.

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
Nope am getting same error ever after uninstalling all the plugins :(

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
Have you tried repairing your tables?

Adrian
Quote Reply
Re: [brewt] [BUG] ?? Can't do build via ssh In reply to
I tried the check and repair function that is available in phpmyadmin and it looked okay.

However just now I copied the SQL query from phpmyadmin and tried to use it via SQL Monitor in GLinks and I got error

Error: Could not execute query: Failed to execute query: 'REPAIR TABLE `lsql_Bad_Link_Track`, ...............etc etc (all lsql_names_here)

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
I just tried the SQL query via Query option in PhpMyAdmin and here is a more specific error I received:

Code:
MySQL said:
#1103 - Incorrect table name 'lsql_Reviews[..]'

However under the list of tables I am able to see "lsql_Reviews".

Vishal
-------------------------------------------------------

Last edited by:

SWDevil.Com: Jul 31, 2009, 3:01 PM
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
Okay after looking further I noticed this message

username_swdir.lsql_Reviews' repair Error Table 'username_swdir.lsql_Reviews'' doesn't exist

However I am able to see the table lsql_Reviews in phpmyadmin :(

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] [BUG] ?? Can't do build via ssh In reply to
Make sure glinks is connecting to the same host and database as phpmyadmin?

Adrian
Quote Reply
Re: [brewt] [BUG] ?? Can't do build via ssh In reply to
Yup it is.. I am logging into phpmyadmin via Cpanel for the site.

Vishal
-------------------------------------------------------
Quote Reply
Re: [brewt] [BUG] ?? Can't do build via ssh In reply to
Any update on how to fix this?

Thanks.

Vishal
-------------------------------------------------------