Need immediate Help!

[virtue]

I was making some changes to my Zen Cart.

Suddently this is what I am getting. See a very ugly outcome! Need immediate help on this!!! THIS IS HORRIFYING!


insert into zen_db_cache set cache_entry_name = 'zc_6ec65decb95a7741ada473af0fde76e1', cache_data = 'a:515:{i:0;a:2:{s:6:\"cfgkey\";s:10:\"STORE_NAME\";s:8:\"cfgvalue\";s:12:\"exop hora.com\";}i:1;a:2:{s:6:\"cfgkey\";s:11:\"STORE_OWNER\";s:8:\"cfgvalue\";s:5:\" admin\";}i:2;a:2:{s:6:\"cfgkey\";s:13:\"STORE_COUNTRY\";s:8:\"cfgvalue\";s:3:\"2 23\";}i:3;a:2:{s:6:\"cfgkey\";s:10:\"STORE_ZONE\";s:8:\"cfgvalue\";s:2:\"61\";}i :4;a:2:{s:6:\"cfgkey\";s:22:\"EXPECTED_PRODUCTS_SORT\";s:8:\"cfgvalue\";s:4:\"de sc\";}i:5;a:2:{s:6:\"cfgkey\";s:23:\"EXPECTED_PRODUCTS_FIELD\";s:8:\"cfgvalue\"; s:13:\"date_expected\";}i:6;a:2:{s:6:\"cfgkey\";s:29:\"USE_DEFAULT_LANGUAGE_CURR ENCY\";s:8:\"cfgvalue\";s:5:\"false\";}i:7;a:2:{s:6:\"cfgkey\";s:25:\"LANGUAGE_D EFAULT_SELECTOR\";s:8:\"cfgvalue\";s:7:\"Default\";}i:8;a:2:{s:6:\"cfgkey\";s:27 :\"SEARCH_ENGINE_FRIENDLY_URLS\";s:8:\"cfgvalue\";s:5:\"false\";}i:9;a:2:{s:6:\" cfgkey\";s:12:\"DISPLAY_CART\";s:8:\"cfgvalue\";s:4:\"true\";}i:10;a:2:{s:6:\"cf gkey\";s:32:\"ADVANCED_SEARCH_DEFAULT_OPERATOR\";s:8:\"cfgvalue\";s:3:\"and\";}i :11;a:2:{s:6:\"cfgkey\";s:18:\"STORE_NAME_ADDRESS\";s:8:\"cfgvalue\";s:38:\"Stor e Name\r\n Address\r\n Country\r\n Phone\";}i:12;a:2:{s:6:\"cfgkey\";s:11:\"SHOW_COUNTS\";s:8:\"cfgvalue\";s:4:\"tr ue\";}i:13;a:2:{s:6:\"cfgkey\";s:18:\"TAX_DECIMAL_PLACES\";s:8:\"cfgvalue\";s:1: \"0\";}i:14;a:2:{s:6:\"cfgkey\";s:22:\"DISPLAY_PRICE_WITH_TAX\";s:8:\"cfgvalue\" ;s:5:\"false\";}i:15;a:2:{s:6:\"cfgkey\";s:28:\"DISPLAY_PRICE_WITH_TAX_ADMIN\";s :8:\"cfgvalue\";s:5:\"false\";}i:16;a:2:{s:6:\"cfgkey\";s:23:\"STORE_PRODUCT_TAX _BASIS\";s:8:\"cfgvalue\";s:8:\"Shipping\";}i:17;a:2:{s:6:\"cfgkey\";s:24:\"STOR E_SHIPPING_TAX_BASIS\";s:8:\"cfgvalue\";s:8:\"Shipping\";}i:18;a:2:{s:6:\"cfgkey \";s:24:\"STORE_TAX_DISPLAY_STATUS\";s:8:\"cfgvalue\";s:1:\"0\";}i:19;a:2:{s:6:\ "cfgkey\";s:21:\"SESSION_TIMEOUT_ADMIN\";s:8:\"cfgvalue\";s:4:\"3600\";}i:20;a:2 :{s:6:\"cfgkey\";s:21:\"GLOBAL_SET_TIME_LIMIT\";s:8:\"cfgvalue\";s:2:\"60\";}i:2 1;a:2:{s:6:\"cfgkey\";s:29:\"SHOW_VERSION_UPDATE_IN_HEADER\";s:8:\"cfgvalue\";s: 4:\"true\";}i:22;a:2:{

[TheOracle]

I was making some changes to my Zen Cart.

When does this SQL error message occurs specificly ?

[virtue]

When I try to link with the shopping cart. I was deleting the default messages on the html so to complete my customization and this is what I am getting.

If this is cannot be fixed, I am thinking of re-installing the cart. But this is such a pain to start all over again. You see what I am saying?

Thanks.

[Sermonzone]

Virtue,

You will need to be much more specific to get help from the Zen masters. Give them a link to the site and "I did this and got this error" kind of detail or they cannot help.

Also, if I am reading the tea leaves correctly, you may be having trouble with the template system. Here is some info I have collected that may help.

Zen Cart is built on a system called ‘overrides.’ When you have worked hard on customizing your site you do not want to lose all that work when a new version or cart update comes along. So, follow the guide for creating a custom template and it will ‘override’ the stock template.

Read, comprehend and apply these threads and you will be blessed by the Zen Cart magic. Your new custom template folder should only contain files that have been edited for your site. Copy the files from template_default, edit them, and make sure they are in the correct ’my_custom_template’ folder.

The Wiki is a great place to start. However, since the forum experienced an emergency reload, many of links have not been updated. Be patient.

http://www.zen-cart.com/wiki/index.p..._-_Customizing
http://www.zen-cart.com/wiki/index.p...on_-_Templates
http://www.zen-cart.com/wiki/index.p..._API_Overrides
http://www.zen-cart.com/wiki/index.php/Basic_Checklist

From the previous forum by NetworkDad is my favorite.

http://www.zen-cart.com/forum/showthread.php?t=7263

Hope some of this helps.

Good luck

[virtue]

Thank you for your good advice Bruce.

Now, I am just confused because when I checked it from a different computer the cart looks normal. But from another computer, it has that crazy look. Was it hacked? Here's the store's link:

www.exophora.com/e-store

I am still working on this (as this is my project) and suddenly I got that weird screen when I tried to go and check the store.

But here's another big error I got. When I tried to configure the SSL to link with LinkPoint, it doesn't save my changes.

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'false');

I am trying to change the "false" to "yes". But it gives me "fatal error or runtime error occured" message and doesn't save the changes.

Is this what is causing it?

Thanks.

[Sermonzone]

Virtue,

When you say

I am still working on this (as this is my project) and suddenly I got that weird screen when I tried to go and check the store.

it is unlikely you will get much help. It is just too vague.

I can only help new zenners with very basic things like the template override. I hope it takes some pressure off the 'big guns' to handle more serious issues.

A problem with the database qualifies as more serious and the only help I can give you is this - to be a specific as possible about the problem. Who does the hosting? what is the exact error message? how did it happen, EXACTLY? etc.

But here's another big error I got. When I tried to configure the SSL to link with LinkPoint, it doesn't save my changes.

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'false');

I am trying to change the "false" to "yes". But it gives me "fatal error or runtime error occured" message and doesn't save the changes.

Is this what is causing it?

I suggest you search for threads on this. I have not dealt with the problem but someone has.

If you don't get some helpful feedback I will PM someone that can likely help. In the meantime, maybe you can work on the content for your custom template and load a test product or two.

i can tell you that I installed and re-installed the cart multiple times at the beginning to get everything set right. I just kept messing something up. After that however, smooth sailing. So don't give up.

Good luck.

[virtue]

Dear Bruce,

I appreciate your advice.

To answer you question:

Our webhosting company is: http://advancednetworkhosts.com/hosting.htm

Now, I don't know but my changes messed up the whole website. The whole site is down. I already emailed the webhosting company since we are now getting this error message:

Forbidden
You don't have permission to access / on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

I know this is such a pain.

[kobra]

An item that you should check is the server name for your SSL in your configure.php file, if you are using a 'shared' SSL it most probably will not be 'yoursite.com'. Verify the SSL site & path and edit accordingly.

  * URLs for your site will be built via:  
   *     HTTP_SERVER plus DIR_WS_ADMIN or
   *     HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or 
   *     HTTP_SERVER plus DIR_WS_CATALOG or 
   *     HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
   * ...depending on your system configuration settings
   */
  define('HTTP_SERVER', 'http://yoursite.com');
  define('HTTPS_SERVER', 'https://yoursite.com');
  define('HTTP_CATALOG_SERVER', 'http://yoursite.com');
  define('HTTPS_CATALOG_SERVER', 'https://yoursite.com');

I am trying to change the "false" to "yes". But it gives me "fatal error or runtime error occured" message and doesn't save the changes.

What are you using to attempt this change? And maybe how are you trying to do this?

If you are attempting to use a file editor in like a cPanel location this could be a problem. Suggest that you use a FTP app and FTP the file to your PC, use notepad or an editor to make change > save and FTP back to your site.

[virtue]

Dear Kobra,

Thank you for your help. I think you are right. I am using the cPanel to make the changes and that is probably the reason why I got the error.

I think see now why I am getting all these errors because everytime I make the changes I use the cPanel.

Thanks again.

Virtue

[kobra]

First, did you determine your HTTPS server name? and get that sorted?

Second, I can't recall exactly what the problem with the cPanel editor is but as the code is very sensitive to characters, I think that this editor tends to add them at inappropriate spots causing errors.

There have been many posts eluding to that fact and I just passed this along to you as your post indicated that you were getting errors trying to edit a file and not being able to save...I know that if you were using an editor on your PC this would not happen. The downside is that you still can make an error in the coding, upload it and then receive an error trying to process your site. At least then you know what file you just changed.