Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.11
PHP version: 5.3.27
MySQL version: 5.5.33-31.1
Host: hostgator
Akeeba Backup version: Akeeba Backup Core 3.7.6

Log: http://citieswestsites.com/CWPBULog.txt

Description of my issue: I tried restoring my site after a backup and am receiving a Database Restoration error. I tried several times, but kept getting the error.

I didn't copy the error, and I don't want to go through the process again unless asked (just in case I'm making things worse).

I selected proceed without restoration and now the site comes up fine, but a bunch of articles aren't working and sometimes Joomla adds &Itemid= to the end of urls causing pages not to load properly.

The reason I wanted to restore is completely unrelated to these current issues.

citieswestsites.com

Thanks for your help...

You have a partial databse restoration or nothing would be there. For the articles that do show on the restored site, is the beginning there, but the end is missing? Does your site use English or another language? Is citieswestsites.com the partially restored site?

I want Nicholas to look at this, it may relate to a database backup bug recently fixed.

Dale

You have a partial databse restoration or nothing would be there.

Perhaps, but the missing articles are in the backend. As far as I can tell, everything is there. It's like the menus items or itemIDs got screwed up and nothing is linking properly.

For the articles that do show on the restored site, is the beginning there, but the end is missing?

The articles appear to be whole. Nothing missing from them that I can see.

Does your site use English or another language?

English only.

Is citieswestsites.com the partially restored site?

Yes. citieswestsites.com is the site I'm referencing

Thank you for looking.

It is not the bug I was thinking of. That's a good thing. I'm still not sure what to do with the error and the menus and itemIDs. I'll leave this flagged for Nicholas.

Dale

Cool. Thank you for looking.

Ok, I re-ran kickstart and got the error again:

An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.

Database error processing line 103
Database server error reply:

SQL=CREATE TABLE `pm_rokgallery_file_loves` ( `file_id` int(10) unsigned NOT NULL DEFAULT '0', `kount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`file_id`), UNIQUE KEY `file_id` (`file_id`), CONSTRAINT `pm_file_loves_file_id_files_id` FOREIGN KEY (`file_id`) REFERENCES `bak_rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `#__rokgallery_file_loves` ( `file_id` int(10) unsigned NOT NULL DEFAULT '0', `kount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`file_id`), UNIQUE KEY `file_id` (`file_id`), CONSTRAINT `pm_file_loves_file_id_files_id` FOREIGN KEY (`file_id`) REFERENCES `bak_rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8

Oh, Thank you - Thank you - Thank you!!!!

I am upgrading as I type this. Great help.

-