Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

zipicip

Pioneers
  • Posts

    59
  • Joined

  • Last visited

Everything posted by zipicip

  1. SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM categories c LEFT JOIN categories_description cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = 1, categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = AND cd.language_id = 1 the category id is missing so something is transmitted wrong in that class when trying to restore shopping cart.
  2. protected $dependencies = array( 'cPath' => array( 'marker' => '-c-', 'query' => "SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM :TABLE_CATEGORIES c LEFT JOIN :TABLE_CATEGORIES_DESCRIPTION cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = :languages_id, :TABLE_CATEGORIES_DESCRIPTION cd WHERE c.categories_id = cd.categories_id AND c.categories_id = :cid AND cd.language_id = :languages_id", page_modules/index.php There is a big problem with this query. If a client try to restore an old cart he get an mysql error 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 'AND cd.language_id = 1' at line 1 SELECT cd2.categories_name AS pName, cd.categories_name AS cName FROM categories c LEFT JOIN categories_description cd2 ON c.parent_id = cd2.categories_id AND c.parent_id = cd2.categories_id AND cd2.language_id = 1, categories_description cd WHERE c.categories_id = cd.categories_id AND c.categories_id = AND cd.language_id = 1 I guess somewhere should by a cast conversion to int to categories id ? You can test if you can enter in a client account . Take table CUSTOMERS_BASKET pick an customers id with an old cart change his password and login and go to shopping cart. Also there error came if a product from cart restore is out of stock now.
  3. [10-Jan-2011 13:20:01] PHP Fatal error: Call to a member function retrieveDependencies() on a non-object in ****/public_html/includes/modules/ultimate_seo_urls5/uri_modules/osc_experimental.php on line 51 this appears pretty often in error log PS: url rewrites works correctly
  4. And the other error Fatal error: Call to a member function store() on a non-object in /home/original/public_html/includes/modules/ultimate_seo_urls5/main/usu5.php on line 78, referer: http I also checked this on forum and there was something similar but I don't now when the error triggers because usually rewrites work fine.
  5. Hello. The contribution works very well but I checked my error log and this is what I found out: PHP Fatal error: Call to a member function retrieveDependencies() on a non-object in /home/original/public_html/includes/modules/ultimate_seo_urls5/main/bootstrap.php on line 409 I read on oscommerce forum that error came from filename that contains "-" instead of " _" is there any way to find out what file is causing the problem ? and exclude that file. Another error: HP Fatal error: Call to a member function store() on a non-object in /home/original/public_html/includes/modules/ultimate_seo_urls5/main/usu5.php on line 78, referer: http I also checked this on forum and there was something similar but I don't now when the error triggers because usually rewrites work fine.
  6. Everything is working fine now it was chemo page cache contribution that was causing that all rewriting url to have same content. Thanks FWR Media (Robert) for this great contribution and for fast support.
  7. Ok. I understand. I sent u an email from oscommerce forum form.
  8. Ok. So I managed to make a test server http://www.originals.ro/server_test/ I let in .httacess only # If you are getting errors you may need to comment this out like .. # Options +FollowSymLinks Options +SymLinksIfOwnerMatch <IfModule mod_rewrite.c> RewriteEngine On # RewriteBase instructions # Change RewriteBase dependent on how your shop is accessed as below. # http://www.mysite.com = RewriteBase / # http://www.mysite.com/catalog/ = RewriteBase /catalog/ # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ # Change RewriteBase using the instructions above RewriteBase /server_test/ RewriteRule ^([a-z0-9-/]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-c-([0-9_]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-m-([0-9]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-pi-([0-9]+).html$ popup_image.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-pr-([0-9]+).html$ product_reviews.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-pri-([0-9]+).html$ product_reviews_info.php [NC,L,QSA] # Articles contribution RewriteRule ^([a-z0-9-/]+)-t-([0-9_]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-au-([0-9]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-a-([0-9]+).html$ article_info.php [NC,L,QSA] # Information pages RewriteRule ^([a-z0-9-/]+)-i-([0-9]+).html$ information.php [NC,L,QSA] # Links contribution RewriteRule ^([a-z0-9-/]+)-links-([0-9_]+).html$ links.php [NC,L,QSA] # Newsdesk contribution RewriteRule ^([a-z0-9-/]+)-n-([0-9]+).html$ newsdesk_info.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-nc-([0-9]+).html$ newsdesk_index.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-nri-([0-9]+).html$ newsdesk_reviews_info.php [NC,L,QSA] RewriteRule ^([a-z0-9-/]+)-nra-([0-9]+).html$ newsdesk_reviews_article.php [NC,L,QSA] </IfModule> I deleted the cache folder. Problem here not even standard doesn't work I don't understand why. I added now mod rewrite and set for debugging.
  9. Yes because that is the live shop and I changed back to standard so no errors will be. If you think that the above scenario doesn't help tonight (I my country) I will make some print screen and set for debug option. What do you need.
  10. domain is www.originals.ro I deleted everything and still no change. Everything goes to index. I managed to simulate something. I changed to rewrite: I entered a product page everything was fine the url was rewrited. I tried to go to another product and then I was redirected to the same product I first rewrited the rule for example. http://mydomain.com/product1-name-p-4714.html http://mydomain.com/product2-name-p-4715.html = same content as http://mydomain.com/product1-name-p-4714.html but url rewrites correctly
  11. Ok here is my .httacess # $Id: .htaccess,v 1.3 2003/06/12 10:53:20 hpdl Exp $ # # This is used with Apache WebServers # # For this to work, you must include the parameter 'Options' to # the AllowOverride configuration # # Example: # # <Directory "/usr/local/apache/htdocs"> # AllowOverride Options # </Directory> # # 'All' with also work. (This configuration is in the # apache/conf/httpd.conf file) # The following makes adjustments to the SSL protocol for Internet # Explorer browsers <IfModule mod_setenvif.c> <IfDefine SSL> SetEnvIf User-Agent ".*MSIE.*" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0 </IfDefine> </IfModule> # Fix certain PHP values # (commented out by default to prevent errors occuring on certain # servers) #<IfModule mod_php4.c> # php_value session.use_trans_sid 0 # php_value register_globals 1 #</IfModule> # If you are getting errors you may need to comment this out like .. # Options +FollowSymLinks Options +SymLinksIfOwnerMatch <IfModule mod_rewrite.c> RewriteEngine On # RewriteBase instructions # Change RewriteBase dependent on how your shop is accessed as below. # http://www.mysite.com = RewriteBase / # http://www.mysite.com/catalog/ = RewriteBase /catalog/ # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ # Change RewriteBase using the instructions above RewriteBase / RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-m-([0-9]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pi-([0-9]+).html$ popup_image.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pr-([0-9]+).html$ product_reviews.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pri-([0-9]+).html$ product_reviews_info.php [NC,L,QSA] # Articles contribution RewriteRule ^([a-z0-9/-]+)-t-([0-9_]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-au-([0-9]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-a-([0-9]+).html$ article_info.php [NC,L,QSA] # Information pages RewriteRule ^([a-z0-9/-]+)-i-([0-9]+).html$ information.php [NC,L,QSA] # Links contribution RewriteRule ^([a-z0-9/-]+)-links-([0-9_]+).html$ links.php [NC,L,QSA] # Newsdesk contribution RewriteRule ^([a-z0-9/-]+)-n-([0-9]+).html$ newsdesk_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nc-([0-9]+).html$ newsdesk_index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nri-([0-9]+).html$ newsdesk_reviews_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nra-([0-9]+).html$ newsdesk_reviews_article.php [NC,L,QSA] </IfModule> # # Skip the next two rewriterules if NOT a spider RewriteCond %{HTTP_USER_AGENT} !(msnbot|slurp|googlebot) [NC] RewriteRule .* - [s=2] # # case: leading and trailing parameters RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+&(.+)$ [NC] RewriteRule (.*) $1?%1&%2 [R=301,L] # # case: leading-only, trailing-only or no additional parameters RewriteCond %{QUERY_STRING} ^(.+)&osCsid=[0-9a-z]+$|^osCsid=[0-9a-z]+&?(.*)$ [NC] RewriteRule (.*) $1?%1 [R=301,L] ErrorDocument 400 /400.shtml ErrorDocument 401 /401.shtml ErrorDocument 404 /403.shtml ErrorDocument 404 /404.shtml # BEGIN Compress text files <IfModule mod_deflate.c> <FilesMatch "\.(css|js|x?html?|php)$"> SetOutputFilter DEFLATE </FilesMatch> </IfModule> # END Compress text files # Turn on Expires and set default expires to 3 days ExpiresActive On ExpiresDefault A259200 # Set up caching on media files for 1 month <FilesMatch "\.(ico|gif|jpg|jpeg|png|flv|pdf|swf|mov|mp3|wmv|ppt)$"> ExpiresDefault A2419200 Header append Cache-Control "public" </FilesMatch> # Set up 2 Hour caching on commonly updated files <FilesMatch "\.(xml|txt|html|js|css)$"> ExpiresDefault A7200 Header append Cache-Control "private, must-revalidate" </FilesMatch> # Force no caching for dynamic files <FilesMatch "\.(php|cgi|pl|htm)$"> ExpiresDefault A0 Header set Cache-Control "no-store, no-cache, must-revalidate, max-age=0" Header set Pragma "no-cache" </FilesMatch> #Options +FollowSymlinks #RewriteEngine on #RewriteCond %{REQUEST_URI} !/maintenance.html$ #RewriteCond %{REMOTE_HOST} !^89\.120\.10\.196 #RewriteRule $ /maintenance.html [R=302,L] Options -Indexes +FollowSymLinks # To redirect all users to access the site WITH the 'www.' prefix, # (http://originals.ro/... will be redirected to http://www.originals.ro/...) # adapt and uncomment the following: RewriteCond %{HTTP_HOST} ^originals\.ro$ [NC] RewriteRule ^(.*)$ http://www.originals.ro/$1 [L,R=301] # REDIRECT /folder/index.php to /folder/ RewriteEngine on RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /([^/]+/)*index\.php\ HTTP/ RewriteRule ^(([^/]+/)*)index\.php$ http://www.originals.ro/$1 [R=301,L] RedirectMatch 301 ^/blog/(.*)$ http://blog.originals.ro/$1 RedirectMatch 301 ^/ecko-romania/(.*)$ http://ecko-romania.originals.ro/$1 Options -Indexes Redirect 301 /informatii.php http://www.originals.ro/information.php Redirect 301 /informatii_originals.php http://www.originals.ro/information.php?info_id=7 Redirect 301 /cum_comand.php http://www.originals.ro/information.php?info_id=8 Redirect 301 /informatii_plata.php http://www.originals.ro/information.php?info_id=9 Redirect 301 /informatii_livrare.php http://www.originals.ro/information.php?info_id=10 Redirect 301 /returnare_produse.php http://www.originals.ro/information.php?info_id=11 Redirect 301 /despre_vouchere.php http://www.originals.ro/information.php?info_id=12 Redirect 301 /fidelizare.php http://www.originals.ro/information.php?info_id=13 Redirect 301 /utilizare_confidentialitate.php http://www.originals.ro/information.php?info_id=14 Redirect 301 /specials.php http://www.originals.ro/reduceri.php Redirect 301 /products_new.php http://www.originals.ro/produse_noi.php <Files .htaccess> order allow,deny deny from all </Files>
  12. I already did this. And same problem. Another thing I discovered. When I change to rewrite mod and access a product page every time he goes to one product page and every time is the same product.
  13. Hello. I was using last Seo Url . Now I updated to the last version and url mod: rewrite doesn't work anymore (that I was using last time). Now everything goes on index.php Any help on debugging this. It only works with standard and path standard.
  14. I don't know if this future exist so here is my question: Let say u added a product in your catalog with name: adidas shoes the link will be generated and crawled by google. After a month u decided to change the name of the product: let say adidas men shoes link will be generated and crawled by google and u get duplicate content I think the seo url class should add a 301 redirect sau google will know that this is the same page.
  15. Problem with state selection: That problem goes that way: Let's say u don't use a dropdown selection for state when customers create an account or u added this future after accounts where already created. When u modify an order first on state field take the customer state . But if this state it isn't on the list when u update your order it takes the first state on the list not the state the customer put . That is because $update_customer_state = tep_get_zone_name($_POST['update_customer_country_id'], $_POST['update_customer_zone_id'], $_POST['update_customer_state']); <tr class="dataTableRow"> <td class="dataTableContent" valign="middle" align="right" nowrap><?php echo ENTRY_CITY_STATE; ?></td> <td colspan="2" valign="top" class="dataTableContent" nowrap><input name="update_customer_city" size="15" value="<?php echo stripslashes($order->customer['city']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_city', encodeURIComponent(this.value))"<?php } ?>>,</td> <td valign="top" class="dataTableContent"><span id="customerStateMenu"> <?php if (ORDER_EDITOR_USE_AJAX == 'true') { echo tep_draw_pull_down_menu('update_customer_zone_id', tep_get_country_zones($order->customer['country_id']), $order->customer['zone_id'], 'style="width: 200px;" onChange="updateOrdersField(\'customers_state\', this.options[this.selectedIndex].text);"'); } else { echo tep_draw_pull_down_menu('update_customer_zone_id', tep_get_country_zones($order->customer['country_id']), $order->customer['zone_id'], 'style="width: 200px;"'); }?></span><span id="customerStateInput"><input name="update_customer_state" size="15" value="<?php echo stripslashes($order->customer['state']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_state', encodeURIComponent(this.value))"<?php } ?>></span></td> </tr> There will always get the first state and when post will verify if state equal 1 and it is always true . U need to make something like this: $array_zones = tep_get_country_zones($order->customer['country_id']) ; but in the select must be a default value: Something like Select a state : ... with id = - 1 .... so when u use post $update_customer_state = tep_get_zone_name($_POST['update_customer_country_id'], $_POST['update_customer_zone_id'], $_POST['update_customer_state']); If the customer state wasn't in the list of state the default value from the customer will be selected Hope someone will implement this so everybody will understand. A good day. My solution: <tr class="dataTableRow"> <td class="dataTableContent" valign="middle" align="right" nowrap><?php echo ENTRY_CITY_STATE; ?></td> <td colspan="2" valign="top" class="dataTableContent" nowrap><input name="update_customer_city" size="15" value="<?php echo stripslashes($order->customer['city']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_city', encodeURIComponent(this.value))"<?php } ?>>,</td> <td valign="top" class="dataTableContent"><span id="customerStateMenu"> <?php if (ORDER_EDITOR_USE_AJAX == 'true') { $zones_array = array(); $zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = ". (int) $order->customer['country_id']. " order by zone_id"); $zones_array[0] = array('id' => '-1', 'text' => 'Select state'); while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); } echo tep_draw_pull_down_menu('update_customer_zone_id', $zones_array, $order->customer['zone_id'], 'style="width: 200px;" onChange="updateOrdersField(\'customers_state\', this.options[this.selectedIndex].text);"'); } else { $zones_array = array(); $zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = ". (int) $order->customer['country_id']. " order by zone_id"); $zones_array[0] = array('id' => '-1', 'text' => 'Select state'); while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); } echo tep_draw_pull_down_menu('update_customer_zone_id', $zones_array, $order->customer['zone_id'], 'style="width: 200px;"'); }?></span><span id="customerStateInput"><input name="update_customer_state" size="15" value="<?php echo stripslashes($order->customer['state']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_state', encodeURIComponent(this.value))"<?php } ?>></span></td> </tr>
  16. Hello. I get this notice in error log PHP Notice: Usu5 cannot find the full filepath, please ensure that DIR_FS_CATALOG in configure.php contains a FULL path in /var/www/sites/*************/html/*************/includes/modules/ultimate_seo_urls5/classes/usu.php on line 97, referer: http://www.*********...*****/index.php WOW I never thought a hosting service could ever be that wrong that they get past my checks!! which version of USU5 are you on? USU5 checks realpath() - getcwd() - and ONLY if they all fail (which they shouldn't) it falls back on your own settings in includes/configure.php for DIR_FS_CATALOG
  17. I changed the product_info name to my mynewnamename .... and the answer is "We found your path to mynewname.php just fine!"
  18. Hello. I get this notice in error log PHP Notice: Usu5 cannot find the full filepath, please ensure that DIR_FS_CATALOG in configure.php contains a FULL path in /var/www/sites/*************/html/*************/includes/modules/ultimate_seo_urls5/classes/usu.php on line 97, referer: http://www.*************.ro/*************/index.php and another strange error File does not exist: /var/www/sites/*************/html/unicprice/index.phpcss, referer: http://www.*************/*************/index.php
  19. Hello. Can someone integrate this contribution with Order Editor http://www.oscommerce.com/community/contri...ch,order+editor
  20. hello this message is for deep-silver who did a greet job I saw that a lot of u guys don't like the fact that redemptions point are not show on checkout_confirmation order_total modules and even more that there aren't deducted from the order I don't have time to implement but here is a hint: ( deep-silver made the module: ot_redemptions.php but he doesn't use it) on includes/classes/order.php at the end of the file where there is if (DISPLAY_PRICE_WITH_TAX == 'true') { $this->info['total'] = $this->info['subtotal'] + $this->info['shipping_cost']; } else { $this->info['total'] = $this->info['subtotal'] + $this->info['tax'] + $this->info['shipping_cost']; } Here u have to ask if u use as always if ((USE_POINTS_SYSTEM == 'true') && (USE_REDEEM_SYSTEM == 'true')) { and here u substract from order total the redemption } and if u want to display your module ot_redemptions.php on checkout page along with ot_subtotat, ot_total, ot_taxxes ... u need to add your module in mysql databes on configuration /// there is a section modules option gID = 6 and there is a option Installed Modules ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php The order is important because this is the order of display on checkout_confirmation So change and it looks like ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_redemptions.php;ot_total.php Hope deep-silver will implement this because he did the contribution and know what I am missing. Sorry for my bad english.
  21. In the end I figure out myself... hope this help somebody if u want to use this contribution and make a cron job add the following: 1. in the script u want to make: let's say test.php add at the begining of the file (the first line is for a file that is in the admin protected area) #!/usr/local/bin/php -q <? define ('execute_cron_job','1'); ?> 2. in admin/includes/application_top.php look for // comment out below line to disable this contribution if (basename($PHP_SELF) != FILENAME_LOGIN_ADMIN && basename($PHP_SELF) != FILENAME_PASSWORD_FORGOTTEN && basename($PHP_SELF) != FILENAME_FORBIDDEN) { tep_admin_check_login(); } and change with if (basename($PHP_SELF) != FILENAME_LOGIN_ADMIN && basename($PHP_SELF) != FILENAME_PASSWORD_FORGOTTEN && basename($PHP_SELF) != FILENAME_FORBIDDEN) { if (execute_cron_job == 1) { $login_id = '1'; $login_groups_id = '1'; $login_firstname = 'test'; tep_session_register('login_id'); tep_session_register('login_groups_id'); tep_session_register('login_first_name'); }else{ tep_admin_check_login(); } } the ideea above is when u came from your script to register your sessions and not the go to the function tep_admin_check_login(); 3. in the script u want to make: let's say test.php add before the ?> // so it doesn't remain any sessions tep_session_unregister('login_id'); tep_session_unregister('login_firstname'); tep_session_unregister('login_groups_id'); So finaly the cron job task looks like: don't forget the php from fron 00 21 * * * php /home/username/public_html/admin/test.php
  22. how to use cron job with this contribution http://www.oscommerce.com/community/contributions,1359 I need a way to auto login
×
×
  • Create New...