|
Monday 05 January 2009 8:39:41 am
I must apologize. I seem to have posted this issue into the wrong forum. If the post could be moved or should I re-post in the correct area? IIS running as localhost windows vista business. PostGreSQL is running on one of our LAN LINUX boxes. The connection to the PostGreSQL server is typically solid. We made an effort yesterday to install the ezpublish cms and managed to get through everything up to a point. I have attached an image of the page just before the error occurs and the error message just after it occurs. Also attached is a portion of the SQL log just as the error occured. It was observed that from the log it appears that the SQL statements may be for MySQL and might not work for PGSQL. The log shows also that all of the earlier SQL statements ran without a problem. Rather than tracking down the code ourselves we opted to have you guys look at the issue since we are not up to speed on your code. We hope this problem is quickly resolved. If the issue is not code related then please could someone give us a heads up on what the issue might be? OOPS I guess I won't be attaching any images. Here is a description of the page just before it failed. The page has "Site Registration" at the top and a check box option to "send registration" at the bottom near the "back" and "next" buttons. Pressing the "next" button is the user event that steps into the code associated with the error. I do <b>note these problems</b> before I press the next button.
php_magicquotes - Success
mbstring_extension - Success
imagegd_extension - Failure
imagemagick_program - Failure
database_all_extensions - Failure
php_register_globals - Success
texttoimage_functions - Failure Not concerned about the image issues currently if the database is having errors. The database_all_extensions failure might be the issue. To address that I followed some leads on the PHP dot net site for placing the following dll's into my system32 folder.
comerr32.dll
gssapi32.dll
k5sprt32.dll
krb5_32.dll
libeay32.dll
libiconv2.dll
libintl3.dll
libpq.dll
ssleay32.dll <b>LOG from PostGreSQL Server.</b>
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:01 EST WARNING: nonstandard use of escape in a string literal at character 251
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:01 EST WARNING: nonstandard use of escape in a string literal at character 259
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:01 EST WARNING: nonstandard use of escape in a string literal at character 259
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:01 EST WARNING: nonstandard use of escape in a string literal at character 260
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:01 EST WARNING: nonstandard use of escape in a string literal at character 260
2009-01-04 14:47:01 EST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2009-01-04 14:47:07 EST WARNING: nonstandard use of \' in a string literal at character 66
2009-01-04 14:47:07 EST HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
2009-01-04 14:47:10 EST ERROR: syntax error at or near "UNSIGNED" at character 131
2009-01-04 14:47:10 EST STATEMENT: CREATE TABLE ezm_block ( id CHAR(32) NOT NULL, zone_id CHAR(32) NOT NULL, name VARCHAR(255) NULL, node_id INTEGER UNSIGNED NOT NULL, overflow_id CHAR(32) NULL, last_update INTEGER UNSIGNED NULL DEFAULT 0, block_type VARCHAR(255) NULL, fetch_params LONGTEXT NULL, rotation_type INTEGER UNSIGNED NULL, rotation_interval INTEGER UNSIGNED NULL, is_removed INTEGER(2) UNSIGNED NULL DEFAULT 0, PRIMARY KEY(id) ) TYPE=InnoDB
2009-01-04 14:47:32 EST ERROR: relation "ezm_block" does not exist
2009-01-04 14:47:32 EST STATEMENT: UPDATE ezm_block SET name='Main story',
overflow_id='',
fetch_params='',
rotation_type='0',
rotation_interval='0'
WHERE id='680b73edef7c07d8f3d9de429b4d9b4d' <b>Error returned to internet browser.</b> Fatal error: A database transaction in eZ Publish failed.
The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-7faceffae81ef23d35ab367e1edd60df and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator. <b>What are the next steps I should take?</b>
|