1.3.9d Error Messages

Hello, A friend and I just updated her zen cart store, we did it via the script available by our webhost, which is fine all seems to be working fine for a bit then we get this error, can someone please advice how to fix please :)

Error #1

 Warning: Division by zero in private/includes/classes/split_page_results.php on line 39

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_RESTRICT_ENTRIES' at line 1
in:
[select * from coupon_restrict where coupon_id = '369' and category_id != '0' limit -0, MAX_DISPLAY_RESTRICT_ENTRIES]

Get than with coupon restrict. Not sure if you need these details below.

MySQL version 5.1.47-community-log

Thanks in advance

I just updated her zen cart store, we did it via the script available by our webhost
Suggest that one never use a script to upgrade

Agreed. You should never use an automated upgrade script. Upgrades should always be done by hand.

At the very least your /admin/includes/languages/english/coupon_restrict.php file appears to be damaged.

kobra:

Suggest that one never use a script to upgrade

Oh boy i wont be doing that again :(

DrByte:

Agreed. You should never use an automated upgrade script. Upgrades should always be done by hand.

At the very least your /admin/includes/languages/english/coupon_restrict.php file appears to be damaged.

Ok so i will reupload a fresh copy and see how it goes, will report back soon

ok once i did that we now get this message

Fatal error: Call to undefined function zen_get_products_manufacturers_name() in admin/coupon_restrict.php on line 285

That suggests that your /admin/includes/functions/general.php is bad, damaged, or outdated.

If you keep running into these kinds of problems, you're likely going to find that you need to go back and just do the upgrade properly, ideally starting from the backup you made before you did the upgrade.

ok i replaced that file and all is fixed, thus far, thank you for your time and help

I hope you're replacing the files with the v1.3.9 version of the file, and not the old one from before the upgrade. You don't want to be mixing versions of files on the server.

DrByte:

I hope you're replacing the files with the v1.3.9 version of the file, and not the old one from before the upgrade. You don't want to be mixing versions of files on the server.

No no i wouldn't do that lol, i replaced it with the updated ones