Support

Site Restoration

#12599 CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW Error

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by nicholas on Saturday, 09 June 2012 10:48 CDT

user64539
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? No
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes

Joomla! version: 2.5
PHP version: 5.2.17
MySQL version: 5.1.62-cll
Host: www.webcity.com.au
Akeeba Backup version which took the backup: Professional 3.5.1
Kickstart version used to extract the backup: 3.5.1

Description of my issue:
Akkeba Backup Installer: DB Restore Error. I have check 'No Dependency Tracking'as per your previous post. I still get the error below. Please help!

Error at the line 158: CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `#__gigcal_gigs_import` AS select `pla14472_missusa`.`jos_gigcal_gigs`.`id` AS `id`,concat(`pla14472_missusa`.`jos_gigcal_gigs`.`band_id`,_utf8'|',`pla14472 ... MySQL: MySQL query failed with error 1146 (Table 'wor18964_supermodel.jos_gigcal_gigs' doesn't exist). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `jwor_gigcal_gigs_import` AS select `pla14472_missusa`.`jos_gigcal_gigs`.`id` AS `id`,concat(`pla14472_missusa`.`jos_gigcal_gigs`.`band_id`,_utf8'|',`pla14472_missusa`.`jos_gigcal_gigs`.`venue_id`,_utf8'|',`pla14472_missusa`.`jos_gigcal_gigs`.`gigdate`) AS `gigname` from `jos_gigcal_gigs`

nicholas
Akeeba Staff
Manager
Ah, I can see what's wrong. The #__gigcal_gigs_import view is referencing tables in a different database. You'll have to use the Database Tables Exclusion page of Akeeba Backup to exclude the #__gigcal_gigs_import view from the backup.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user64539
Thankyou for your response. I am now getting the following error:

Error at the line 1: INSERT INTO `#__acymailing_config` VALUES ('level', 'Starter'), ('version', '3.6.0'), ('from_name', 'demo'), ('from_email', '[email protected]'), ('reply_name', 'demo'), ('reply_email', '[email protected]'), ('bounce ... MySQL: MySQL query failed with error 1146 (Table 'wor18964_supermodel.jwor_acymailing_config' doesn't exist). The query was:INSERT INTO `jwor_acymailing_config` VALUES ('level', 'Starter'), ('version', '3.6.0'), ('from_name', 'demo'), ('from_email', '[email protected]'), ('reply_name', 'demo'), ('reply_email', '[email protected]'), ('bounce_email', ''), ('add_names', '1'), ('mailer_method', 'mail'), ('encoding_format', '8bit'), ('charset', 'UTF-8'), ('word_wrapping', '150'), ('hostname', ''), ('embed_images', '0'), ('embed_files', '1'), ('editor', '0'), ('multiple_part', '1'), ('sendmail_path', '/usr/sbin/sendmail'), ('smtp_host', 'localhost'), ('smtp_port', ''), ('smtp_secured', ''), ('smtp_auth', '0'), ('smtp_username', ''), ('smtp_password', ''), ('smtp_keepalive', '1'), ('queue_nbmail', '40'), ('queue_nbmail_auto', '70'), ('queue_type', 'auto'), ('queue_delay', '3600'), ('queue_try', '3'), ('queue_pause', '120'), ('allow_visitor', '1'), ('require_confirmation', '0'), ('priority_newsletter', '3'), ('allowedfiles', 'zip,doc,docx,pdf,xls,txt,gzip,rar,jpg,gif,xlsx,pps,csv,bmp,epg,ico,odg,odp,ods,odt,png,ppt,swf,xcf,mp3,wma'), ('uploadfolder', 'media/com_acymailing/upload'), ('confirm_redirect', ''), ('subscription_message', '1'), ('notification_unsuball', ''), ('cron_next', '1251990901'), ('confirmation_message', '1'), ('welcome_message', '1'), ('unsub_message', '1'), ('cron_last', '0'), ('cron_fromip', ''), ('cron_report', ''), ('cron_frequency', '900'), ('cron_sendreport', '2'), ('cron_sendto', '[email protected]'), ('cron_fullreport', '1'), ('cron_savereport', '2'), ('cron_savepath', 'media/com_acymailing/logs/report989942024.log'), ('notification_created', ''), ('notification_accept', ''), ('notification_refuse', ''), ('forward', '0'), ('description_starter', 'Joomla!β„’ E-mail Marketing'), ('description_essential', 'Joomla!β„’ Newsletter Extension'), ('description_business', 'Joomla!β„’ Newsletter System'), ('description_enterprise', 'Joomla!β„’ Newsletter Extension'), ('priority_followup', '2'), ('unsub_redirect', ''), ('show_footer', '1'), ('use_sef', '0'), ('itemid', '0'), ('css_module', 'default'), ('css_frontend', 'default'), ('css_backend', 'default'), ('installcomplete', '1'), ('Starter', '0'), ('Essential', '1'), ('Business', '2'), ('Enterprise', '3'), ('menu_position', 'under')

nicholas
Akeeba Staff
Manager
What is the database table name prefix of the site you are backing up? Also, are you backing up multiple databases?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user64539
The prefix is jos_

I am not backing up multiple databases.

user64539
I made the prefix for the destination site the same and it works.

Thankyou so much for your help and well done for writing a great App.

nicholas
Akeeba Staff
Manager
What I see is that when you are trying to restore your site, the tables are not created. So when we try to restore the data to the table, MySQL complains that the table doesn't exist. Does the MySQL user has adequate privileges to create tables?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user64539
Not sure if there were sufficient privileges. I will have to speak to my hosting company about this.

user64539
I have tested the site and it has transferred successfully.

nicholas
Akeeba Staff
Manager
Well, I'm glad the transfer has been completed!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!