Jump to content

UGAChance

Member
  • Posts

    54
  • Joined

  • Last visited

Everything posted by UGAChance

  1. 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
  2. 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.
  3. 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.
  4. 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.
  5. SOLVED! Found out my dad somehow made Category 1 have a parent of Category 60.... which was a hidden Category.
  6. 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
  7. 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
  8. 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?
  9. 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
  10. Nevermind... moving to a whole new post.
  11. 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.
  12. I take it that it would be safe to "Empty" the CubeCart_SEO-URL Database Table... it will regenerate?
  13. 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
  14. 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.
  15. I get these error messages in the Error Logs alot of times. Is this just because it is trying to create the SEO Link if it is not there? Today, 17:58 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1880','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty2-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1 Today, 17:58 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1881','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty2-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1 Today, 17:58 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1581','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty-1-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1 Today, 17:56 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1295','coins/half-dollars/kennedy-half-dollars/un-certified-kennedy-half-dollars/1966-ms-65-kennedy-half-dollar');" - Duplicate entry 'coins/half-dollars/kennedy-half-dollars/un-certified-kennedy-hal' for key 1 Today, 16:14 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1880','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty2-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1 Today, 16:14 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1881','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty2-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1 Today, 16:14 File: [seo.class.php] Line: [534] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`) VALUES ('prod','1581','coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-ty-1-ms-63-buffalo-nickel');" - Duplicate entry 'coins/nickels/buffalo-nickels/un-certified-buffalo-nickels/1913-' for key 1
  16. Thanks for elaborating on that point. You'll be pleased to know that the issues is way more likely to have been one with server support than CC500 so justice was done in the end. Regards, Jules Same here. I have seen the invalid IP address line a couple times. I have lost all the store settings a couple times too and I do not know what triggered it. I have had to go to CubeCart Dashboard and Unlock the License and relock it a couple times too.
  17. Don't despair. V5 Plugin to enhance group functionality is in the works and will be released shortly. Stay tuned to cubecartforums.org Thanks /Goober How about a surcharge for specific categories or products... not customer based but category based. Example... want to add a surcharge of 2-3% on Gold in a Coin Store for transactions(All transactions are credit card). Haven't tried the options in CC5 yet to see if it will accomplish this... will your mod allow this? Thanks, Shane
  18. I had CC4 with LinkPoint Payment Gateway Module. The .pem file went in the LinkPoint_API directory. Where does the "0000000.pem" go for the FirstData Payment Gateway? Store home directory, Payment Gateway Directory, FirstData Directory, or other? Thanks, Shane
  19. Is there a way to View/Sort all the Products of a certain Category. In other words... see what Products are in which Category.... what Category they are a member of. Another suggestion is to add a (# of Products) and (# of Categories) to the Title/Header of the Admin Page for example: Product Inventory Product Inventory(1721) Thanks, Shane
  20. I had this error come up in the system log... is someone trying to hack the site through Search? Hello(2) and World(11) were mine by the way. Looks like either in the code or in the search string someone was trying to use C code comments /* */ and it came through as +(*http://pwtsyccqipcw.com/*)? Search Term Hits Percentage of total hits 1 Http://nndntmejcauj.com/ 1 100.00 2 Hello 0 0.00 3 Http://pwtsyccqipcw.com/ 0 0.00 4 Nickels 0 0.00 5 Buffalo 0 0.00 6 Http://mdgajhuotdjg.com/ 0 0.00 7 Certfiates 0 0.00 8 Silver 0 0.00 9 Http://npicsqhutuar.com/ 0 0.00 10 1.00 0 0.00 11 World 0 0.00 12 Nndntmejcauj 0 0.00 Today, 22:26 File: [catalogue.class.php] Line: [915] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 83.81, G.price >= 83.81) AND IF (G.price IS NULL, I.price <= 8.4, G.price <= 8.4) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) ORDER BY name ASC LIMIT 20 OFFSET 0" - 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 'ORDER BY name ASC LIMIT 20 OFFSET 0' at line 1 Today, 22:26 File: [catalogue.class.php] Line: [918] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 83.81, G.price >= 83.81) AND IF (G.price IS NULL, I.price <= 8.4, G.price <= 8.4) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) GROUP BY I.product_id ORDER BY name ASC" - 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 'GROUP BY I.product_id ORDER BY name ASC' at line 1 Today, 22:26 File: [catalogue.class.php] Line: [915] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 83.81, G.price >= 83.81) AND IF (G.price IS NULL, I.price <= 8.4, G.price <= 8.4) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) ORDER BY name ASC LIMIT 20 OFFSET 0" - 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 'ORDER BY name ASC LIMIT 20 OFFSET 0' at line 1 Today, 22:26 File: [catalogue.class.php] Line: [918] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://pwtsyccqipcw.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 83.81, G.price >= 83.81) AND IF (G.price IS NULL, I.price <= 8.4, G.price <= 8.4) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) GROUP BY I.product_id ORDER BY name ASC" - 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 'GROUP BY I.product_id ORDER BY name ASC' at line 1 Today, 19:18 File: [catalogue.class.php] Line: [915] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://nndntmejcauj.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://nndntmejcauj.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 81.905, G.price >= 81.905) AND IF (G.price IS NULL, I.price <= 10.5, G.price <= 10.5) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) ORDER BY date_added ASC LIMIT 20 OFFSET 0" - 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 'ORDER BY date_added ASC LIMIT 20 OFFSET 0' at line 1 Today, 19:18 File: [catalogue.class.php] Line: [918] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://nndntmejcauj.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://nndntmejcauj.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 81.905, G.price >= 81.905) AND IF (G.price IS NULL, I.price <= 10.5, G.price <= 10.5) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) GROUP BY I.product_id ORDER BY date_added ASC" - 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 'GROUP BY I.product_id ORDER BY date_added ASC' at line 1 Today, 14:22 File: [catalogue.class.php] Line: [915] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 1.905, G.price >= 1.905) AND IF (G.price IS NULL, I.price <= 4.2, G.price <= 4.2) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) ORDER BY name DESC LIMIT 20 OFFSET 0" - 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 'ORDER BY name DESC LIMIT 20 OFFSET 0' at line 1 Today, 14:22 File: [catalogue.class.php] Line: [918] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 1.905, G.price >= 1.905) AND IF (G.price IS NULL, I.price <= 4.2, G.price <= 4.2) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) GROUP BY I.product_id ORDER BY name DESC" - 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 'GROUP BY I.product_id ORDER BY name DESC' at line 1 Today, 14:22 File: [catalogue.class.php] Line: [915] "SELECT I.*, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 1.905, G.price >= 1.905) AND IF (G.price IS NULL, I.price <= 4.2, G.price <= 4.2) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) ORDER BY name DESC LIMIT 20 OFFSET 0" - 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 'ORDER BY name DESC LIMIT 20 OFFSET 0' at line 1 Today, 14:22 File: [catalogue.class.php] Line: [918] "SELECT COUNT(I.product_id) as count, MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (MATCH (I.product_code,I.name,I.description) AGAINST('+(*http://mdgajhuotdjg.com/*)' IN BOOLEAN MODE)) >= 0.500000 AND IF (G.price IS NULL, I.price >= 1.905, G.price >= 1.905) AND IF (G.price IS NULL, I.price <= 4.2, G.price <= 4.2) AND I.featured = '1' AND ((I.use_stock_level = '0') OR (I.use_stock_level = '1' AND (I.stock_level > 0 OR I.stock_by_option = '1')) GROUP BY I.product_id ORDER BY name DESC" - 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 'GROUP BY I.product_id ORDER BY name DESC' at line 1 Today, 11:35 [Error] /hermes/bosweb/web061/b616/ipw.cccoinsatlanta/public_html/CUBECART_5/includes/functions.inc.php:416 - Invalid IP address
  21. I had to go throught some hoops last night to uprgade from CC5 RC2 to CC 5.0.0... licensing wise. 1. I copied CC 5.0.0 over CC5 RC2. 2. It came up and said enter License #.... I was using 55555-55555-whatever. 3. I entered my old license for CC4. 4. Said invalid. 5. I tried to get 45 day license... wouldn't let me since I am already a user of CC4. 6. I paid $50 for License 4 to 5. It still said invalid. I didn't realize I had to "unlock" the license from domain and then enter it again in admin. All is fine now.
  22. FYI: CubeCart 5 passed. I did an upgrade from CubeCart 4.4.5 to CubeCart 5 ... same database and all.
  23. http://www.cccoinsatlanta.com/index.php?searchStr=&_a=viewCat&Submit=Go http://www.cccoinsatlanta.com/index.php?searchStr=&_a=viewCat&Submit=Go%22%3Cspan http://www.cccoinsatlanta.com/index.php?searchStr=+and+1%3D1&_a=viewCat&Submit=Go%22 http://www.cccoinsatlanta.com/index.php?searchStr=+and+1%3D0&_a=viewCat&Submit=Go%22 http://www.cccoinsatlanta.com/index.php?searchStr=+and+1%3D1&_a=viewCat&Submit=Go%22%3E http://www.cccoinsatlanta.com/index.php?searchStr=+and+1%3D0&_a=viewCat&Submit=Go%22%3E It is not sanitizing #4 and #6 that have "%3D0"
×
×
  • Create New...