Bulk Edit Product Names & Descriptions

[maria82g]

Unfortunately "Failed" does not provide enough information to diagnose the specific issue that is identified on your system. Please either provide the specific error message, or if the query was run from within the ZC admin Install SQL patches section, an error log should have been generated in the cache directory if in fact you are still using ZC 1.3.9h... otherwise In the logs directory for ZC 1.5.1 and above. Look for myDebugxxxx related files.. If it is an admin myDebug (which is expected) do not post your admin directory as part of the information (Replace with something else).

Hi Thanks for responding, it was not in admin folder
but in the directory root of zencart all 3 files, have same text must be because of the three times I attempted sql patch
this is what it says

[04-Mar-2015 15:11:03 UTC] PHP Parse error: syntax error, unexpected '}' in /hermes/bosnaweb10a/b1526/ipg.sitecom/mydirectory/includes/functions/sessions.php on line 16

[mc12345678]

That's actually not directly related to this issue, but trying the sql may have illuminated or helped discover an issue.

Before suggesting how to correct that one, what php version is your store on and what are your plans for upgrading?

[maria82g]

MySQL Version 5.5.32
Perl Version 5.8.8
PHP Version 5.3

No plans of upgrading PHP

[mc12345678]

MySQL Version 5.5.32
Perl Version 5.8.8
PHP Version 5.3

No plans of upgrading PHP

Sorry, should have been clearer on the question, what plans do you have for upgrading zc? I know that using php 5.4 with zc 1.3.9 causes issues, but at the moment not sure about the version currently used.

So it seems like either the sessions.php file has been modified, or in "putting together" the php code to present the page, something had/has an additional right curly bracket } that causes one of them in the sessions file to "close" the file prematurely. Tracking that down could be "fun", but not impossible.

Perhaps could try a very generic SQL statement and see if the same type of error occurs?

select * from products;

There is no "result" expected, but hopefully no failure either. Double check the logs at that point.

[maria82g]

Sorry, should have been clearer on the question, what plans do you have for upgrading zc? I know that using php 5.4 with zc 1.3.9 causes issues, but at the moment not sure about the version currently used.

So it seems like either the sessions.php file has been modified, or in "putting together" the php code to present the page, something had/has an additional right curly bracket } that causes one of them in the sessions file to "close" the file prematurely. Tracking that down could be "fun", but not impossible.

Perhaps could try a very generic SQL statement and see if the same type of error occurs?

select * from products;

There is no "result" expected, but hopefully no failure either. Double check the logs at that point.

yep "1 statement processed"

Log file : after processing the statement, there is no new MYDEBUG file....

[mc12345678]

If the sessions.php file hasn't been modified since the issue was first discovered, perhaps you could post the version you have at least up to the line number previously provided. Please place between CODE tags that are generated when selecting the # symbol in the ttolbox are of responding to this message.

If the seesions.php file was modified perhaps in response to a similar post in the forum, perhaps could link to it.

[maria82g]

If the sessions.php file hasn't been modified since the issue was first discovered, perhaps you could post the version you have at least up to the line number previously provided. Please place between CODE tags that are generated when selecting the # symbol in the ttolbox are of responding to this message.

If the seesions.php file was modified perhaps in response to a similar post in the forum, perhaps could link to it.

umm sessions.php?

what I have in my logs folder are files with names

myDEBUG-1394660064-450695.log , each one has different numbers..
is there anyplace else I should look for sessions.php?