Not able to edit any product. Shows 500 Server Error.

Hi,



I have one cs-cart installation running on cloud server and I have installed another cs-cart instance on same domain (subdomain).



I have imported products & categories table from old database to new database and now new installations shows all products (by clicking Products->Products menu) in admin panel, But now when I click on any product it shows 500 internal server error and shows nothing.



I have checked rest everything is working in admin panel. It is letting me create new product, but when I click on submit it creates new product (by reading URL i guess it has created product because it shows new product id) but again showing 500 error,



SO any idea where is the problem, I think it is not issue of server because rest everything is working. Please help to resolve this issue. Thanks,



Regards,

Vinic

Hi there,



Did you import the tables of the db through PhpMyAdmin or did you export through product csv and then again import through product csv?





Did it worked before the import?



If you tried it through PhpMyAdmin there is a big chance you missed some tables, cause its not only products and categories tables.



Fotis

Hi,



Thanks for reply.

[quote name='dvsgr' timestamp='1334732467' post='135021'] If you tried it through PhpMyAdmin there is a big chance you missed some tables, cause its not only products and categories tables. Fotis [/quote]



Yes I have imported products using phpmyadmin, i have imported all cscart_product* and cscart_categories*so what other tabels I need to import. Can you please specify.



Thanks,

Hi again



I wouldnt do that, instead export trough admin all the products in csv format from old store and import them again through admin.



Versions have different table names sometimes or different cell names, and you also might messing up the ids that the system creates.



It is very risky, complicated and time consuming to test all the tables and cell names, and thats why the 500 problem you get.



Try again through import export it is much easier and faster.



Fotis

Well, agree with you but actually I have 8000 products in my store, and as per cs-cart process we can only export 100 products at a time. So is there any other way to export & import all products at one shot?

Have you checked file/folder permissions, checked the php.ini file and checked the server logs?



A 500 internal server error usually means something is wrong with the script (ie pemissions) or writing to a file (ie folder permissions).



In my experiences, if the database is screwed up, you would get a SQL error not a 500 error.

If it worked before the product import then its a db problem.



If not then investigate this

  1. wrong file permissions of CS-Cart files
  2. wrong .htaccess file
  3. general a server error (Mod_security Regex modifications are necessary), contact your webhost
  4. PHP version is not ok (too new?), contact your webhost



    About the 100 product limit I am not sure, what version is that?



    Lastly have a look at the system specifications for cs-cart if you meet them[list]

    []PHP version 5.1 or greater;

    [
    ]MySQL version 4.1 or greater.

    [/list]

    This makes CS-Cart compatible with almost every server that supports PHP and MySQL. However, we recommend Apache or any interchangeable alternative as the most robust and stable server for your web store.

    Other requirements and recommendations include:[list]

    []safe_mod is disabled;

    [
    ]GD library is installed;

    []cURL support is enabled;

    This PHP extension is required to ensure support for secure connections and some payment systems, including PayPal, Authorize.Net and Google Checkout, as well as real-time shipping rate calculators for FedEx and DHL/Airborne;

    [
    ]file_uploads is enabled;

    [*].htaccess file (if supported) should have the following directives allowed: DirectoryIndex, Deny, Allow, Options, Order, AddHandler, RewriteEngine, RewriteBase, RewriteCond and RewriteRule.

    [/list]

Thanks for your reply.


[quote name='dvsgr' timestamp='1334904052' post='135161']

If it worked before the product import then its a db problem.

[/quote]

Well I haven;t tried adding products before importing products using db. SO i am not sure this problem was before or not.


[quote name='dvsgr' timestamp='1334904052' post='135161']

About the 100 product limit I am not sure, what version is that?

[/quote]



I am using CS-2.2.3 actually by 100 limit i mean when you click on products and select products by clicking check all and then choose action-> export. I am using this way, is there any other method to export all products?

[quote name='vinic' timestamp='1335267850' post='135338']is there any other method to export all products?

[/quote]



Administration->Export->Products

[quote name='The Tool' timestamp='1335271504' post='135344']

Administration->Export->Products

[/quote]



I have tried this method too, but I have 7500 products in my store and when i used this option to export products, export products progress bar stucked at 3300 products and no progress onward.



Problem still persist, any suggestion pleaseā€¦