Gossamer Forum
Home : Products : Gossamer Links : Discussions :

links sql - making me reinstall?

Quote Reply
links sql - making me reinstall?
my site has been up for years and has been using links sql. My host goes down alot and when my host went down the other day it screwed up my links sql. i have over 2000 links so i need to save this site. The website still shows and i can still see my pages but when i try to access the backend i get this..



Welcome to Links SQL. Before you can begin to use the program, we need to setup Links SQL to work with your SQL server. You will need to know the following information before proceeding:
  • SQL Server Type - common types include mysql, MS-SQL, Oracle
  • SQL Hostname - which computer your sql server resides on, typically this is localhost.
  • SQL Database Name - which database you want Links SQL to use.
  • SQL Username/Password - a username/password to log on to the SQL database.


If you don't know the answer



then it asks me in another page if i want to make new tables, overwrite etc. How do i save my site? I don't have a backup recent - a few weeks old and it doens't include someone installing the new templates and programming some code so i will be out of nearly a $100 in costs. Please help and tell me how to make it normal again
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
Probably the same problem I had a little while ago.

In admin/Links/ConfigData.pm, what do you have defined for 'setup' ?

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 - making me reinstall? In reply to
# ==================================================================
# Links SQL - enhanced directory management system
#
# Website : http://gossamer-threads.com/
# Support : http://gossamer-threads.com/support/
# Updated : Wed Nov 19 03:02:38 2003
#
# Copyright (c) 2001 Gossamer Threads Inc. All Rights Reserved.
# Redistribution in part or in whole strictly prohibited. Please
# see LICENSE file for full details.
# ==================================================================

{
'add_system_fields' => {
'Hits' => '0',
'Rating' => '0',
'Status' => '0',
'Votes' => '0',
'isChanged' => 'No',
'isNew' => 'No',
'isPopular' => 'No'
},
'admin_email_add' => '1',
'admin_email_mod' => '1',
'admin_root_path' => '/home/onlyscri/public_html/linksSQL/admin',
'admin_root_url' => 'http://www.onlyscripts.com/linksSQL/admin',
'bans' => [],
'build_auto_validate' => '0',
'build_category_columns' => '2',
'build_category_sort' => 'Name',
'build_category_table' => 'border=0 width="100%"',
'build_category_yahoo' => '1',
'build_cool_gb' => '1',
'build_cool_path' => '/home/onlyscri/public_html/linksSQL/pages/Cool',
'build_cool_url' => 'http://www.onlyscripts.com/linksSQL/pages/Cool',
'build_css_url' => 'http://www.onlyscripts.com/linksSQL/pages/links.css',
'build_default_tpl' => 'onscript',
'build_detail_path' => '/home/onlyscri/public_html/linksSQL/pages/Detailed',
'build_detail_url' => 'http://www.onlyscripts.com/linksSQL/pages/Detailed',
'build_detailed' => '1',
'build_dir_per' => '0777',
'build_directory_field' => '',
'build_extension' => '.html',
'build_file_per' => '0666',
'build_images_url' => 'http://www.onlyscripts.com/linksSQL/pages/images',
'build_index' => 'index.html',
'build_links_per_page' => '25',
'build_new_cutoff' => '7',
'build_new_gb' => '1',
'build_new_path' => '/home/onlyscri/public_html/linksSQL/pages/New',
'build_new_url' => 'http://www.onlyscripts.com/linksSQL/pages/New',
'build_pop_cutoff' => '0.01',
'build_ratings_path' => '/home/onlyscri/public_html/linksSQL/pages/Ratings',
'build_ratings_url' => 'http://www.onlyscripts.com/linksSQL/pages/Ratings',
'build_root_path' => '/home/onlyscri/public_html/linksSQL/pages',
'build_root_url' => 'http://www.onlyscripts.com/linksSQL/pages',
'build_search_gb' => '1',
'build_sort_order_category' => 'isNew DESC,isPopular DESC,Title',
'build_sort_order_cool' => 'Title',
'build_sort_order_new' => 'Add_Date DESC,Title',
'build_sort_order_search' => 'score',
'build_sort_order_search_cat' => 'score',
'build_span_pages' => '1',
'build_use_backup' => '1',
'child_path' => '/home/onlyscri/public_html/linksSQL/admin/verify-child.pl',
'compress' => '1',
'date_days_long' => [
'Sunday',
'Monday',
'Tuesday',
'Wednesday',
'Thursday',
'Friday',
'Saturday'
],
'date_days_short' => [
'Sun',
'Mon',
'Tue',
'Wed',
'Thu',
'Fri',
'Sat'
],
'date_db_format' => '%yyyy%-%mm%-%dd%',
'date_long_format' => '%dddd%, %mmmm% %dd% %yyyy%',
'date_month_long' => [
'January',
'February',
'March',
'April',
'May',
'June',
'July',
'August',
'September',
'October',
'November',
'December'
],
'date_month_short' => [
'Jan',
'Feb',
'Mar',
'Apr',
'May',
'Jun',
'Jul',
'Aug',
'Sep',
'Oct',
'Nov',
'Dec'
],
'date_offset' => '0',
'date_user_format' => '%ddd% %mmm% %dd% %yyyy%',
'db_admin_email' => 'jeff@onlyscripts.com',
'db_cgi_url' => 'http://www.onlyscripts.com/linksSQL',
'db_gen_category_list' => '1',
'db_hit_expire' => '2',
'db_mail_path' => '/usr/sbin/sendmail',
'db_php_url' => 'http://www.onlyscripts.com/linksSQL',
'db_rate_expire' => '2',
'db_referers' => [],
'db_smtp_server' => '',
'debug_level' => '0',
'disabled' => '0',
'dynamic_pages' => '1',
'dynamic_preserve' => [
't',
'd',
's'
],
'editor_email_add' => '0',
'email_add' => '1',
'email_mod' => '1',
'error_message' => '',
'fileman_root_dir' => '/home/onlyscri/public_html/linksSQL/admin',
'foreign_char' => '0',
'last_build' => '1069070787',
'nph_headers' => '1',
'path_to_perl' => '/usr/bin/perl',
'private_sessions' => '1',
'quick_links' => {
'admin.cgi?do=page&page=tools_validate.html' => 'Validate Links',
'admin.cgi?do=page&page=tools_validate_reviews.html' => 'Validate Reviews',
'nph-build.cgi' => 'Build All'
},
'reg_number' => '5124-03-LQ',
'review_convert_br_tags' => '1',
'review_days_old' => '7',
'review_sort_by' => 'Review_Date',
'reviews_per_page' => '5',
'search_blocked' => [],
'search_bold' => '1',
'search_bool' => 'AND',
'search_maxhits' => '25',
'search_substring' => '0',
'setup' => '0',
'user_allow_pass' => '1',
'user_direct_mod' => '0',
'user_rate_required' => '0',
'user_required' => '0',
'user_review_required' => '1',
'user_session_length' => '3',
'user_sessions' => 'Cookies',
'user_validation' => '0',
'version' => '2.1.2'
};

# vim:syn=perl:ts=4
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
Try changing;

'setup' => '0',

to

'setup' => '1',

I'm not sure why it does this... but it seems to be happening quite a bit recently on one of my installations Frown

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 - making me reinstall? In reply to
thanks andy...

i am able to login now but can't change anything cause i get this fatal error

A fatal error has occured:
GT::SQL (18841): File '/home/onlyscri/public_html/linksSQL/admin/defs/Links.def' does not exist or the permissions are set incorrectly at /home/onlyscri/public_html/linksSQL/admin/Links.pm line 514.


Please enable debugging in setup for more details.
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
In /admin/defs/database.def, what do you have set for 'prefix' ? Also, what other files exist in that folder? (just name a few)

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 - making me reinstall? In reply to
i don't have a database.def in there



i have lsql_verify.def

lsql_users.def

lsql_category.def

lsql_links.def etc
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
Mmm Unsure

All I can suggest is re-doing the installation, and making sure you set it to NOT overwrite the tables.

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: [SinisterX] links sql - making me reinstall? In reply to
And I would also suggest to download the full mysql dump ASAP. So in any case, you never loose your data.

Hope this helps.

NS

Vishal
-------------------------------------------------------
Quote Reply
Re: [NeedScripts.Com] links sql - making me reinstall? In reply to
if i reinstall without checking overwrite then i will be ok? nothing will be damaged?

Iwill download the dump....



Also if i look in a backup and just have the database.def can i just upload that? let me know - it would prob be a month old
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
>>>if i reinstall without checking overwrite then i will be ok? nothing will be damaged?<<<

As long as you make sure you select the option which means the database tables will not be overwritten.

>>>Also if i look in a backup and just have the database.def can i just upload that? let me know - it would prob be a month old <<<<

It shouldn't matter how old it is, as long as you havn't had any database changes within that time period.

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 - making me reinstall? In reply to
database changes as in?



new links added recently? yes

new template went up - yes

now there are different color folders which change when new stuff is added



if any of these 3 make a difference let me know
Quote Reply
Re: [SinisterX] links sql - making me reinstall? In reply to
I was refering to things like database name, username, password, etc.

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!