Linux.com

Home Linux Community Forums Linux System Administration Web Management upgrade my website without disturbing current load

upgrade my website without disturbing current load

Link to this post 07 Apr 11

I am getting this error after upgrading eZpublish version from 4.3 to 4.5

EZSW-004
Failed inserting data to mysql
Table 'ezapprove_items' already exists

Link to this post 08 Apr 11

That is a very literal error message, the upgrade is attempting to build a new table under the same name as an existing table. There are numerous ways to work around this depending on the potential for table structure changes. I recommend replicating the table to a new name, deleting the existing table, allowing the script to create the new table then appending the data from the old table to the new one.

Link to this post 08 Apr 11

i did this thing ...after that i am facing same problem for 3 more table .......then again same table error come

Link to this post 08 Apr 11

At this point it sounds like you are using an installation script rather than an upgrade script. The difference is that an installer will attempt to build a new structure which yours is doing and an upgrade script will only modify the tables to the new format.

If what you are attempting to do is following the upgrade script from the project then I recommend contacting the project developers to alert them of the issue so they can work with you to find a stable solution.

Link to this post 08 Apr 11

I had downloaded eZpublish 4.5 version from internet
then i had overwrite it in my folder "/var/www/testeZ/"
then when i access my site
"http://192.168.1.206/testeZ/index.php"
it is showing setup wizard .............at the end i got this error

EZSW-004
Failed inserting data to mysql
Table 'ezapprove_items' already exists

I am not understanding difference between installation script and upgrade script.

Link to this post 08 Apr 11

Site info:

Site package - plain_site
Title - Plain site
URL - http://192.168.1.206/testeZ/index.php/plain_site
Admin URL - http://192.168.1.206/testeZ/index.php/plain_site_admin
Access type - url
Access value - plain_site


Web server info:
Version - Apache/2.2.3 (Red Hat)

PHP info:
Version - 5.3.4

OS info
Name - Linux linserver2.jzero.com 2.6.18-194.el5PAE #1 SMP Tue Mar 16 22:00:21 EDT 2010 i686
CPU Type - Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
CPU Speed - 1600.000 MHz
Memory Size - 4212879360 (3.92 GB)

Database info:
Type - MySQL Improved
Driver - ezmysqli


Email info:
Transport - sendmail

Image conversion:
ImageMagick was found and used.
Path - /usr/bin
Executable - convert
ImageGD extension was found and used.

Regional info:
Primary - eng-US
Additional - eng-US

Critical tests

directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
safe_mode - Success
memory_limit - Success
execution_time - Success
magic_quotes_runtime - Success
allow_url_fopen - Success
accept_path_info - Success
php_session - Success
file_upload - Success
zlib_extension - Success
dom_extension - Success
iconv_extension - Success
mbstring_extension - Success
timezone - Success
ezcversion - Success

Other tests:

variables_order - Failure
php_magicquotes - Success
curl_extension - Success
imagegd_extension - Success
imagemagick_program - Success
database_all_extensions - Success
php_register_globals - Success
texttoimage_functions - Success
open_basedir - Success

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board