Problems after moving to new server

Can't get it installed? Not sure how a feature works? Then post here.

Problems after moving to new server

Postby peter76 » 2011-02-24 05:57 pm

Hi all I inherited a top sites from someone else installed the sql back up and all is fine. I also installed the change admin password mod did that and now I cant login. I get this error:

Code: Select all
Fatal error: Database error in "/home/removed/public_html/sources/admin.php" on line 139

Table 'typonli_tempdelias.top_sites_edited' doesn't exist in /home/removed/public_html/sources/sql/mysql.php on line 88


I tried running a query that I found on here but didn't work. Any ideas? Thanks
peter76
Newbie
 
Posts: 2
Joined: 2011-02-24 05:54 pm

Re: Problems after moving to new server

Postby Basti » 2011-02-25 02:06 pm

Its because a file has a bug in the current and past releases which was not noticed for quite some time.

do this if you backup your site in the future through the admin. its a fix in the file.
http://www.osempire.com/community/showt ... hp?t=11871

To fix you current issue, run this query using phpmyadmin
Code: Select all
CREATE TABLE `top_sites_edited` (
                    `username` varchar(255) default '' NOT NULL,
                    `url` varchar(255) default '',
                    `title` varchar(255) default '',
                    PRIMARY KEY  (`username`)
                  );
Basti
Advanced Member
 
Posts: 1619
Joined: 2004-06-20 06:17 pm
Location: Germany


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest