Problems after moving to new server

[peter76]

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

[Basti]

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`)
                  );