

CosmeaNailArt
-
Content count
3 -
Joined
-
Last visited
Posts posted by CosmeaNailArt
-
-
Hi Ian (if you haven't given up),
I'm very new to this, so apologies for the messy code, but we had the same problem.
count(distinct *) is where the error is; it's generated in catalog\includes\classes\split_page_results.php
As a quick and dirty fix I just added the following:
// Mod - added line below below to avoid sql error on catalog/specials.php
if ($count_string = 'distinct *') $count_string = 'distinct p.products_id';
under
if (strpos($this->sql_query, 'distinct') || strpos($this->sql_query, 'group by')) {
$count_string = 'distinct ' . tep_db_input($count_key);
} else {
$count_string = tep_db_input($count_key);
}
( at about line 53 in catalog\includes\classes\split_page_results.php )
I don't have time just now to look into why it's trying to build the expression the wrong way, but at least this fixes it after it does so.
Someone may be along shortly with a more elegant solution!
With this fix is the specials.php page is repaired. On the otherside account_history.php won't work anymore. If you remove the fix account_history.php will work again, and specials.php won't.
So it's a choice you'll have to make, or someone else has a solution for this????
Tjappie W
-
Hello,
Great contrib, Jack!
But i'm having a small problem with the cronjob. This is the cron job:
/usr/local/bin/php -q -f /home/****/domains/cosmeanailart.nl/private_html/googlesitemap/index.php
The e-mail i receive from my hosting shows me an error:
Warning: require_once(includes/configure.php): failed to open stream: No such file or directory in /home/***/domains/cosmeanailart.nl/public_html/googlesitemap/index.php on line 47 Fatal error: require_once(): Failed opening required 'includes/configure.php' (include_path='.:/usr/local/lib/php') in /home/***/domains/cosmeanailart.nl/public_html/googlesitemap/index.php on line 47
What do I need to change to get the conjob work?
If you need additional information, please let me know.
Tjappie W
[Contribution] iOSC - mobile version of OSC on your iPhone
in General Add-Ons Support
Posted
Hello all,
I've uploaded a new version iOSC3 (http://addons.oscommerce.com/info/7636). See change log below:
New Release (v4.0) of iOSC - mobile version of OSCommerce for iPhone and smartphone
Changelog v4.0:
Cosmetic changes:
* Dutch translation
* "Mobile" removed from title (mobile/includes/header.php)
* Greeting on mobile_index.php is now multilangual
* Buy NOW button is now multilangual (mobile_product_info.php + all languages)
* Buy NOW button is now multilangual (mobile_product_reviews.php + all languages)
* Added Language to header, Home button removed
* Non used images removed
* Store address added to mobile_contact_us.php (still need some editing)
* Confirm password is now multilangual
* Button PC Site again added
Bugfixes:
* BUGFIX: Auto redirect to mobiele home page didn't work (includes/functions/iosc.php)
- $targetPage = "mobile_index.php"; changed in $targetPage = "../mobile_index.php";
* BUGFIX: Checkout process goes trough classic site (mobile/includes/configure.php)
- define mobile_checkout_process.php added
* BUGFIX: After a succes order the customer wasn't redirected to the homepage (mobile_checkout_succes.php)
- MOBILE removed from FILENAME_MOBILE_CHECKOUT_SUCCESS
* BUGFIX: Link to reviews repaired (mobile/includes/configure.php)
- define mobile_product_reviews.php added
* BUGFIX: link to product_review_write repaired (mobile/includes/configure.php)
- define mobile_product_reviews_write.php added
*BUGFIX: PayPal, iDEAL, CC payments, etc didn't work (mobile_checkout_confirmation.php)(thnx to pixclinic)
- "echo $payment_modules->process_button();" added (without quotes!!) after "if (is_array($payment_modules->modules)) {"
- NOTE: This will save sensitive data on your server. It's up to you to decide wether or not you might want to save creditcard data on your server. There is a contribution that you might want to add to your store that encrypts data via MD5 at: (http://www.oscommerce.com/community/contributions,4359). It is strongly recommended if you use the cc module.
*BUGFIX: Auto redirect for smartphones etc edited (thnx to Escaping for the solution, reposted by wflynn)
-NOTE: the auto redirect works, but the switch from mobile to classic gives some problems. I'm still working on this one, a great part of ths contribution needs to be rewritten. As a temperory solution you could install Custom HTTP Error Page (http://addons.oscommerce.com/info/933). This way you'll won't lose potential customers.
Other:
* Rewrote installation.txt
To do:
* Complete rewrite so the link to the classic site works as it should be
* Add a module (specials or whats new) to mobile_index.php
* Some editing on the store address in mobile_contact_us.php
* (Re)write some other contribs for iOSC (like Purchase Without Account, Points and Rewards and Discount Coupon, etc).
Have a look at http://www.cosmeanailart.nl/mobile/ for an example. This is a live shop.....
Thanks to the original writers and contributers of this contribution.