Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Database structure in 2.0.5 compared to 2.1.0

Quote Reply
Database structure in 2.0.5 compared to 2.1.0
Ok, I got a really annoying problem here! For some reason, someones database (for an import I am doing, is configured really odd. The tables are, for example;

Build_Update
Category
CategoryAlternates
CategoryHierarchy

What are these tables? I looked in their setup area, and it was set to use Links_ as the table starter, but as you can see this is not the case here.

Anyone shed any light on it?

Thanks

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: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
Anyone?

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: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
You gonna share the payment if I give you an answer? Wink
Quote Reply
Re: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
Are you sure you are looking in the right database?

What error messages are you getting during the attempted import?


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
Umm isn't category a default table anyway?
Quote Reply
Re: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
Hi,

Most likely they did not have a prefix originally, and are now using a prefix.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [pugdog] Database structure in 2.0.5 compared to 2.1.0 In reply to
Yeah, the database is correct. The way I did it was as follows;

Take a dump of their original SQL Database

Exeute the query so it is added to the database on my server.

Execute perl /home/ace-host.com/public_html/dump/cgi/admin/nph-import.cgi --import=RDF --source=/home/ace-host.com/public_html/small_dumps/society.dump.slice --destination=/home/ace-host.com/public_html/dump/cgi/admin/defs --rdf-category="Top/Society" --rdf-add-date="2001-01-01" --rdf-update

Then look at it via page.cgi. The categories are there, but for some reason when I click on a cateogry, it brings up a page saying;

A fatal error has occured:
Can't call method "fetchrow_hashref" on an undefined value at /home/ace-host.com/public_html/dump/cgi/admin/Links/Link.pm line 384.


Please enable debugging in setup for more details.

This seems to point to it being a SQL Database / table error. But I just can't pinpoint it Frown

Anyone seen this before?



Alex

I didn't think you were allowed to use no prefex when setting up the database? Unsure

Thanks

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: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
after importing the tables, did you "repair" them?

Also, if you enable debugging, as indicated, it should point you right to the error.

Usually, this error (in the sites I've been trying to upgrade) has been a missing table or table column, or something that was fixed by installing the program properly.

The 2.1 upgrade routine doesn't always seem to try to upgrade/update the database. I saw it do it once, but on other installs, I didn't see it do the upgrades (add the table and a column).


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Database structure in 2.0.5 compared to 2.1.0 In reply to
Lol...I forgot to repair Tongue I'm damn sure I did it...spose I should always double check Blush. Thanks everyone....

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: [pugdog] Database structure in 2.0.5 compared to 2.1.0 In reply to
Doh...shouldn't have spoken so soon Wink

Ok, some categories are working fine now (such as http://207.230.62.131/...2Findex.html&d=1), but others, such as http://207.230.62.131/...2Findex.html&d=1 gives me an error! I'm wondering if it was the problem that you spoke about, where he is using 2.0.5, and I'm using 2.1.0. Maybe I should set up a 2.0.5 copy on my server, and see if it runs ok on that Tongue

I'll let you know how it goes, unless you have any other hints for me Smile

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: [AndyNewby] Database structure in 2.0.5 compared to 2.1.0 In reply to
What plugins do you have installed? When upgrading, it's better to uninstall all the plugins, or at least deactivate the calls. See if links runs without anything external.

2.1.0 handles this much different, and if you have a plugin running, that might be part of the issue. It's hard to tell, exactly.

You might have to reinstall the plugins to make sure they set up the environment they need correctly.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Database structure in 2.0.5 compared to 2.1.0 In reply to
Sorry, forgot to reply. Its all ok now. It was a version problem. I was using 2.1.0, but it needed 2.0.5 to run. Thanks everyone, its annoying when it was so simple Tongue

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!