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
 
 
 
 
 
 
 
 
 
 
Linux Community Forums Linux System Administration Web Management upgrade my website without disturbing current load
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
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.
08 Apr 11
i did this thing ...after that i am facing same problem for 3 more table .......then again same table error come
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.
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.
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
The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.
Join / Linux Training / Board
