I just upgraded from 3.4.1 to 4.0.12. No error messages but when I click on a link from my Main page they all take me to a blank page with no source code. I have access to the admin pages but when I click on Browse Categories I get a 404 page not found error. I'm not sure what to do. I have uploaded and upgraded a couple of times without any progress.
When you can't click a category that's usually an htaccess issue. Have you tried turning rewriting off to check?
Edit: that's not it. Checking your debug at www.sdrox.com/San_Diego/ind...displaycat&catid=8&debug=1 I see "Unknown column 'effectivetime' in 'where clause'". Do you not have effectivetime in your wsnlinks_links table? Run upgrade.php again. It's coming up with blank counts it seems so maybe the table needs repair, though it doesn't indicate it.
I tried running the upgrade again a couple of times but did not help. I turned rewriting off.
When before I run the upgrade I get this message: The following queries will need to be performed to add new fields ...
ALTER TABLE wsnlinks_links ADD validatedemail int default '0' NOT NULL; ALTER TABLE wsnlinks_links ADD unpaid int default '0' NOT NULL; ALTER TABLE wsnlinks_links ADD recipverified int default '0' NOT NULL; ALTER TABLE wsnlinks_links ADD effectivetime int default '0' NOT NULL; ALTER TABLE wsnlinks_links ADD sugcatid int default '0' NOT NULL; ALTER TABLE wsnlinks_links ADD wysihtml int default '0' NOT NULL;
They since they keep showing up I guess they did not run correctly. I tried running the first query through phpMyadmin and got this error message:
Database San_Diego - Table wsnlinks_trader running on localhost
Error
SQL-query :
ALTER TABLE wsnlinks_links ADD validatedemail int default '0' NOT NULL
MySQL said: #1060 - Duplicate column name 'recipurl'
I ran the upgrade in debug mode and attached the output. I also ran Repair Database Tables from the admin pannel but did not help. I don't know what to do now.
There seems to be something about your table preventing any fields from being added. Do you have two fields named 'recipurl' (even though that should be impossible)? If so, remove one or both and try the query again.
If you want to give me your phpmyadmin info I can have a look.
Please, please do not type my email out in the open for all the spam spiders. Also, don't send me direct emails (except as replies to recent exchanges) because that email will change the next time it gets posted long enough for the spam spiders to find it, forcing me to abandon it. Use the support form on the site.
It was a problem with the table index for wsnlinks_links specifying the same column twice. Deleted the index so it works now.
Comments on upgrade - lost links
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
I just upgraded from 3.4.1 to 4.0.12. No error messages but when I click on a link from my Main page they all take me to a blank page with no source code. I have access to the admin pages but when I click on Browse Categories I get a 404 page not found error. I'm not sure what to do. I have uploaded and upgraded a couple of times without any progress.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
When you can't click a category that's usually an htaccess issue. Have you tried turning rewriting off to check?
Edit: that's not it. Checking your debug at www.sdrox.com/San_Diego/ind...displaycat&catid=8&debug=1 I see "Unknown column 'effectivetime' in 'where clause'". Do you not have effectivetime in your wsnlinks_links table? Run upgrade.php again. It's coming up with blank counts it seems so maybe the table needs repair, though it doesn't indicate it.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
I tried running the upgrade again a couple of times but did not help. I turned rewriting off.
When before I run the upgrade I get this message: The following queries will need to be performed to add new fields ...
ALTER TABLE wsnlinks_links ADD validatedemail int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD unpaid int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD recipverified int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD effectivetime int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD sugcatid int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD wysihtml int default '0' NOT NULL;
They since they keep showing up I guess they did not run correctly. I tried running the first query through phpMyadmin and got this error message:
Database San_Diego - Table wsnlinks_trader running on localhost
Error
SQL-query :
ALTER TABLE wsnlinks_links ADD validatedemail int default '0' NOT NULL
MySQL said:
#1060 - Duplicate column name 'recipurl'
I ran the upgrade in debug mode and attached the output. I also ran Repair Database Tables from the admin pannel but did not help. I don't know what to do now.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There seems to be something about your table preventing any fields from being added. Do you have two fields named 'recipurl' (even though that should be impossible)? If so, remove one or both and try the query again.
If you want to give me your phpmyadmin info I can have a look.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
I sent an email to [removed] with phpmyadmin info.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Please, please do not type my email out in the open for all the spam spiders. Also, don't send me direct emails (except as replies to recent exchanges) because that email will change the next time it gets posted long enough for the spam spiders to find it, forcing me to abandon it. Use the support form on the site.
It was a problem with the table index for wsnlinks_links specifying the same column twice. Deleted the index so it works now.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
Thanks for your help, sorry about the email. I didn't want to post my myphpadmin info on the public forum.