UGAChance

Is there a way to change the Site Settings store http address if you can't access the admin page? My dad discontinued the SSL Secure Certificate without my knowledge and now the store is broken due to it being setup for "https://" Are those settings in the database? Can I change them if I have MySQL access? Thanks in advance, Shane

Is it wrong that I have two 5.0.8 versions in the history? id version time Edit Delete 1 5.0.7 1328764904 Edit Delete 2 5.0.8 1335670090 Edit Delete 3 5.0.8 1335670100 Edit Delete 4 5.0.9 1336516374 Edit Delete 5 5.1.0 1339141593 I started with 5.0.0, but I wiped the database at some point and started fresh, but imported products back in.

It has been doing this I think since 5.0.0... I am on the latest and have been updating every version. I fixed it once, but it came back. I am not sure what I did to fix it because I was clearing cache, rebuilding Sitemap, etc.

Latest Products on Homepage switches to only showing 5 instead of 6. Has anyone seen this? This keeps happening and I have no idea why. The Homepage Layout Settings still says 6, but only 5 show.... the first 5. The last one is empty/blank. I can change it to say 9 and 8 display. It doesn't matter what number I change it to, it is always 1 less.

SOLVED! Found out my dad somehow made Category 1 have a parent of Category 60.... which was a hidden Category.

I upgraded from 5.0.7 to 5.0.8 recently and my dad said he was adding categories and it would goto the Hopepage. I tried it and it would also goto the homepage when I tried "Add Category" and "Rebuild Sitemap." One category is missing from the homepage now, but it still shows up in the MySQL database. I tried cleaning cache, turning it off, and all kinds of other things. I turned on debug and this is what I was getting: PHP: [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/1fc4f18114799b188bdaf6649f70cb984f06a36c.file.maintenance.index.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/1fc4f18114799b188bdaf6649f70cb984f06a36c.file.maintenance.index.php.php) [function.unlink.php]: No such file or directory [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/244674c60a366fbe64cd9cdf7032eda2a5214e6b.file.main.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/244674c60a366fbe64cd9cdf7032eda2a5214e6b.file.main.php.php) [function.unlink.php]: No such file or directory [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/5f12b3844da8e78166bbf16c7e23e744b32114b1.file.common.gui_message.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/5f12b3844da8e78166bbf16c7e23e744b32114b1.file.common.gui_message.php.php) [function.unlink.php]: No such file or directory

I am getting with 5.0.8: PHP: [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/1fc4f18114799b188bdaf6649f70cb984f06a36c.file.maintenance.index.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/1fc4f18114799b188bdaf6649f70cb984f06a36c.file.maintenance.index.php.php) [function.unlink.php]: No such file or directory [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/244674c60a366fbe64cd9cdf7032eda2a5214e6b.file.main.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/244674c60a366fbe64cd9cdf7032eda2a5214e6b.file.main.php.php) [function.unlink.php]: No such file or directory [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_resource.php:693 - filemtime() [function.filemtime.php]: stat failed for /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/5f12b3844da8e78166bbf16c7e23e744b32114b1.file.common.gui_message.php.php [Warning] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/lib/smarty/sysplugins/smarty_internal_write_file.php:49 - unlink(/hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/cache/skin/5f12b3844da8e78166bbf16c7e23e744b32114b1.file.common.gui_message.php.php) [function.unlink.php]: No such file or directory

Yes I saw this too. 3 of them.... 2 of them were from China and 1 was from Seattle. I was wondering if this was a bug or someone was trying to inject a session. Maybe a robot trying to inject a session?

No prefix.

Maintenance->Database->Analyze It is appending the database name to the front of the table... I think and it is throwing it off. System Error Log Date Message Today, 20:46 File: [maintenance.index.inc.php] Line: [117] "ANALYZE TABLE `cubecart5.CubeCart_access_log`,`cubecart5.CubeCart_addressbook`,`cubecart5.CubeCart_admin_error_log`,`cubecart5.CubeCart_admin_log`,`cubecart5.CubeCart_admin_users`,`cubecart5.CubeCart_alt_shipping`,`cubecart5.CubeCart_alt_shipping_prices`,`cubecart5.CubeCart_blocker`,`cubecart5.CubeCart_category`,`cubecart5.CubeCart_category_index`,`cubecart5.CubeCart_category_language`,`cubecart5.CubeCart_config`,`cubecart5.CubeCart_coupons`,`cubecart5.CubeCart_currency`,`cubecart5.CubeCart_customer`,`cubecart5.CubeCart_customer_group`,`cubecart5.CubeCart_customer_membership`,`cubecart5.CubeCart_documents`,`cubecart5.CubeCart_downloads`,`cubecart5.CubeCart_email_content`,`cubecart5.CubeCart_email_template`,`cubecart5.CubeCart_filemanager`,`cubecart5.CubeCart_geo_country`,`cubecart5.CubeCart_geo_zone`,`cubecart5.CubeCart_history`,`cubecart5.CubeCart_hooks`,`cubecart5.CubeCart_image_index`,`cubecart5.CubeCart_inventory`,`cubecart5.CubeCart_inventory_language`,`cubecart5.CubeCart_lang_strings`,`cubecart5.CubeCart_logo`,`cubecart5.CubeCart_manufacturers`,`cubecart5.CubeCart_modules`,`cubecart5.CubeCart_newsletter`,`cubecart5.CubeCart_newsletter_subscriber`,`cubecart5.CubeCart_openid`,`cubecart5.CubeCart_option_assign`,`cubecart5.CubeCart_option_group`,`cubecart5.CubeCart_option_value`,`cubecart5.CubeCart_options_set`,`cubecart5.CubeCart_options_set_member`,`cubecart5.CubeCart_options_set_product`,`cubecart5.CubeCart_order_history`,`cubecart5.CubeCart_order_inventory`,`cubecart5.CubeCart_order_notes`,`cubecart5.CubeCart_order_summary`,`cubecart5.CubeCart_order_tax`,`cubecart5.CubeCart_permissions`,`cubecart5.CubeCart_pricing_group`,`cubecart5.CubeCart_pricing_quantity`,`cubecart5.CubeCart_request_log`,`cubecart5.CubeCart_reviews`,`cubecart5.CubeCart_search`,`cubecart5.CubeCart_seo_urls`,`cubecart5.CubeCart_sessions`,`cubecart5.CubeCart_system_error_log`,`cubecart5.CubeCart_tax_class`,`cubecart5.CubeCart_tax_details`,`cubecart5.CubeCart_tax_rates`,`cubecart5.CubeCart_trackback`,`cubecart5.CubeCart_transactions`;" - Incorrect table name 'cubecart5.CubeCart_access_log' Today, 20:40 File: [maintenance.index.inc.php] Line: [117] "ANALYZE TABLE `cubecart5.CubeCart_seo_urls`;" - Incorrect table name 'cubecart5.CubeCart_seo_urls' Today, 20:40 [Error] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/functions.inc.php:416 - Invalid IP address

Nevermind... moving to a whole new post.

I think I am going to start clean. I just wish the export of products kept the image associations. My dad has 1400 products or so and he is NOT that computer literate... and I do not have much time or energy outside of work since I am a Senior Software Engineer during the day. So, I am the webmaster even though I am a Linux C++ embedded applications programmer and only know enough html/php to get the job done. If I export the 4.4.5 products to excel... I will have to manually make the category row be something like category_id "1"... and then redo the categories in CC5... it would be hard to make the cat ids add up. I will import the excel sheet to CC5 and just make cat_id "1" be a temp category and then re-associate category 1 to whatever the new cat_id becomes.

I take it that it would be safe to "Empty" the CubeCart_SEO-URL Database Table... it will regenerate?

It was from CC4 and even maybe CC3... to CC5.RC2.... then to CC5. Good catch... My dad's website stresses CubeCart because no 2 products are alike... there is a 1-to-1 relationship... Rare coins they are each unique. Also... the categories go a couple levels deep... ex. Home->Coins->Cents->Small Cents->Indian Head Cents->Un-Certified Indian Head Cents Home->Coins->Cents->Small Cents->Indian Head Cents->Certified Indian Head Cents

Mine was an upgrade from 4.4.5 to 5.0.RC2... and then to 5.0.0. I do not know if it is related to Clearing Logs/Cache or turning SEO on/off or installing the .htaccess. P.S. Installing .htaccess and turning SEO off causes problems.