I have just installed 4.5.5 this on my test site running 1.5.5f & if I make any changes using admin/ceon_uri_mapping_config.php I get the following error:
PHP Fatal error: 1366:Incorrect integer value: '' for column 'automatic_version_checking' at row 1 :: update ceon_uri_mapping_configs set autogen_new = '1', whitespace_replacement = '1', capitalisation = '3', remove_words = '-', char_str_replacements = '€=>EUR', mapping_clash_action = 'auto-append', manage_product_reviews_mappings = '0', manage_product_reviews_info_mappings = '0', manage_product_reviews_write_mappings = '0', automatic_version_checking = '' where id = '1'
I have checked the database & ceon_uri_mapping_configs.automatic_version_checking has a value of 1
Both of the installation checks are happy & report no errors.
Does anyone have any idea of what could be causing this or where I should look to find the issue?
Thanks for your help
Pat
It appears that there is/was an attempt to modify the automatic-version-checking option to off or not to be performed; however, it was not handled properly either in the attempt to remove the version checking option or if it was present, but the appropriate posted information did not contain an expected value.
A solution that appears acceptable is at/around line 507 of admin/includes/classes/class.CeonURIMappingConfigUtility.php to change:
To:Code:$this->_automatic_version_checking = $_POSTt'automatic-version-checking'];
By adding the casting of integer.Code:$this->_automatic_version_checking = (int)$_POSTt'automatic-version-checking'];
I would recommend this regardless of whether version checking returns or remains unavailable to ensure that only an integer value be considered for storage into the database.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Thanks for your speedy response. I found the code at line 477 & made the alteration & the error has gone away.
Just an FYI for anyone following later:
Is a typo & should beCode:$_POSTt'automatic-version-checking']
Code:$_POST['automatic-version-checking']
Well heck. I thought all was good and then not. I am running 1.5.5f. I am not using an "unused" domain, but the store is live. myfurnituretx.com
I am having a problem when updating or adding products to the store. After clicking "preview" upon updating or adding a product, I receive a blank screen (should be insert or update). When I toggle the "Offer Auto-generation of URIs for Categories, Products, Manufacturers and EZ-Pages:" to No, all is good. But when on yes, it does not work. My urls are also not changing when in selecting yes or no. I did an installation check and all checks out good. I copied and pasted the rewrite .htaccess file and loaded to the root.
htaccess file is:
RewriteEngine On
# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
# Don't rewrite any URIs for some, popular specific file format extensions,
# which are not covered by main file extension condition above
RewriteCond %{REQUEST_URI} !\.(mp3|mp4|h264)$ [NC]
# Don't rewrite any URIs for some specific file format extensions,
# which are not covered by main file extension condition above
# Uncomment the following line to apply this condition! (Remove the # at the start of the next line)
#RewriteCond %{REQUEST_URI} !\.(3gp|3g2|h261|h263|mj2|mjp2|mp4v|mpg4|m1v|m2v|m4u|f4v|m4v|3dml)$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/cr_admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors/ [NC]
# Don't rewrite .well-known directory
RewriteCond %{REQUEST_URI} !^/\.well\-known/ [NC]
# Don't rewrite logs directory
RewriteCond %{REQUEST_URI} !^/logs/ [NC]
# Don't rewrite cgi-bin directory
RewriteCond %{REQUEST_URI} !^/cgi\-bin/ [NC]
# Handle all other URIs using Zen Cart (its index.php)
RewriteRule .* index.php [QSA,L]
## END CEON URI MAPPING REWRITE RULE
I did see a couple of the typos mentioned on the class.CeonURIMappingConfigUtility.php file and updated, but still no luck. I have a feeling there is something simple I am missing. Sorry, I couldn't find it in this thread.
Any help would be great!
Ok, so now that perhaps the panic has subsided... Some additional information would help:
1. has Ceon URI Mapping been installed against the database of this site before? And if so, what was its operational status?
2. When the blank page was created, a log file should have been generated in the logs directory or if not logged there at least in the server logs (possibly requires help from the host). What did that log identify? (would suggest not posting the admin directory name although that has already been done in posting of the full .htaccess file. (Suggest renaming the admin directory.)
3. Regarding the lack of provided rewritten uris shown on the store front, has the plugin been enabled in the configuration settings?
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
There is no panic. This is a temporary domain that I use. My hope is to get this working if not, I will simply remove it and move on to something that works for me. However, I would like to get it working. To answer your questions.
1. There was not a pre-existing database. I added a couple of dummy products to test. No luck of course.
2. Yes a log was created, but nothing to do with the admin. Specifically: "PHP Parse error: syntax error, unexpected ':', expecting ';' or '{' in /home/[login]/public_html/includes/classes/class.StringHelper.php on line 68:
3. Yes it was enabled.
Hopefully that is enough information to find help. Regards.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
line 68
public function setDefaultCharset($charset): void
CEON URI Mapping 4.5.5. downloaded from the plugins. I am using 1.5.5f. I think that is what you are asking for.
Thanks for your time.
Last edited by creyesx6; 22 Oct 2018 at 06:12 PM.
I sincerely appreciate your time and for looking into this for me. However, I have decided to move on to a different option. Thanks for contributing to this free plugin. I was privileged enough to have worked with Conor before his passing and I appreciate all his great work as well.
Bookmarks