WordPress.org

1. sireneweb
   Member
   Posted 4 months ago #
   

   Hi,
   When i try backup my MYSQL DB with PHPmyadmin, i get an error with wp_mla_alt_text_view, can you give me the structure or the sql table structure to restore by default.

   It's very strange, because this table is considering as view and not as INNoDB type.

   CREATE ALGORITHM=UNDEFINED DEFINER=mydbuser@%SQL SECURITY DEFINER VIEWwp_mla_alt_text_viewAS selectwp_postmeta.post_idASpost_id,wp_postmeta.meta_valueASmeta_valuefromwp_postmetawhere (wp_postmeta.meta_key= '_wp_attachment_image_alt');

   http://wordpress.org/extend/plugins/media-library-assistant/

2. David Lingren
   Member
   Plugin Author
   Posted 4 months ago #
   

   Thank you for this report and for using the plugin.

   I use WordPress Database Backup (Version 2.2.3 | By Austin Matzko) for our site and had similar problems. BackWPup, another plugin, had problems in the past but they claim to have improved things in their latest version.

   I solved my problem by just eliminating the view from my backups. This is harmless, because Media Library Assistant will recreate the view if it's missing. You can safely eliminate the view from your backups if that's an option.

   The view is required for proper handling of the ALT Text field when the Media/Assistant table listing is sorted on that field. I will see if I can dynamically add the view only when necessary and not leave it hanging around in the database. That shouldn't be necessary, but it would work around the shortcomings of various backup utilities.

3. sireneweb
   Member
   Posted 4 months ago #
   

   Thanks for your feedback, i use mysqldump and Plesk to do my operation. Why you don't create this table instead use view ?

4. David Lingren
   Member
   Plugin Author
   Posted 4 months ago #
   

   First, to answer your question about creating a table instead of a view: the complexity of maintaing a "real" database table for this specialized function is not worth the expense and the risk. The only time this information is used is when a keyword search or a sort on the ALT Text field is requested. Since this is fairly rare, maintaining a table doesn't seem like a good investment.

   In fact, I have just released version 1.10, which adds the view only when required and drops it immediately after use. Since the view exists only when using the ALT Text features of the plugin, it should no longer cause any trouble with backup/restore utilities.

   Thanks again for your comments and for using the plugin.

5. sireneweb
   Member
   Posted 4 months ago #
   

   ok, thanks for this new fix, i use BackWPup now to backup my database and i exclude automaticly this table. I like your plugin, i hope to see in the futur in media popup library the filter for media library assistant :)

Reply

You must log in to post.