Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

MOD: Sales SMS Notification v1.0 Rate Topic   - - - - -

 

Posted 19 March 2007 - 05:07 PM #21

Thanks, I tried it but still errors in the tables.

 
  • MikeK
  • Senior Member
  • Members
  • Join Date: 26-Apr 06
  • 434 posts

Posted 19 March 2007 - 06:00 PM #22

Thanks, I tried it but still errors in the tables.


Is it giving you the same error or something new. Please post the message.

Cheers,
Mike

 

Posted 19 March 2007 - 08:50 PM #23

When you delete that line of code it reads the same error but jumps to the next line of code;
SQL query:
INSERT INTO cscart_language_values( lang_code, name, value )
VALUES ("EN", "sms_sms_not", "SMS Notification");

MySQL said:
#1062 - Duplicate entry 'EN-sms_sms' for key 1

then when you check the Error this pops up

SQL query:
SELECT *
FROM Array
WHERE CONCAT_WS( "-", lang_code, name, value ) = "en-sms_sms"
ORDER BY lang_code, name, value
LIMIT 0 , 30
MySQL said:
#1146 - Table 'mystore_cscart.Array' doesn't exist

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 31 March 2007 - 04:27 PM #24

well, he cant get the same error if he took that line out.......
sounds like a user-error......

and since he was so nice before (altho it has been deleted now i see):

Originally Posted by tribalboy3000
So yes, you do get what you pay for and thats a whole lot of nothing in this case.

..... i think i'll let this one skip ;)

 

Posted 01 April 2007 - 03:01 PM #25

Its all good, Im sure Im not the only one who will run into problems with it. Besides I tried to get ahold of you 3 weeks ago for help.

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 01 April 2007 - 07:01 PM #26

then try replacing all

INSERT INTO

into

REPLACE INTO

and run again.......

 

Posted 02 April 2007 - 06:12 PM #27

nwsco, I tried the fix but no go, I appreciate your help and again apologize for the negative comments, Im sure this is a fine mod and it would be a nice seeling point to clients that would like this feature. Is it suppose to work upon check out? Meaning after you leave your cart and go to payment gateway, the text message should be sent?

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 11 April 2007 - 05:49 PM #28

just a note here to inform you of a new version that fixes a lot of
issues that i heard of in the last year, like not working with some
paymentgateways etc.

for the ones that already have the mod implemented, but want to
know the, by far, most important change:

-open /core/fn_sms.php
-REPLACE line 50 that now reads:
@fn_send_mail_plain($email__to, $settings['Company']['company_orders_department'], $email__subj, $sms_body, '', $settings['Appearance']['admin_default_language']);


with this line:
$sms_mailed = @mail($email__to,$email__subj, $sms_body);


good luck

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 18 May 2007 - 08:45 PM #29

nwsco,

Just wanted to say GREAT MOD :D !!!

Can I use it to send to two addresses, like 555@domain.com; 556@domain.com?
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 18 May 2007 - 08:57 PM #30

thanks.

yes, you should be able to yes, divide with a comma, not semicolon, so like this:

user@example.com, anotheruser@example.com

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 18 May 2007 - 11:04 PM #31

Thanks! It works great!
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 31 May 2007 - 12:07 PM #32

I guess I am havinag a problem with the mod using paypal. When the user tries to go back to me site they get:

Database 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 '' at line 1
Invalid query: SELECT payment FROM cscart_payment_descriptions WHERE payment_id=

Backtrace:
File: /home/ladysere/public_html/shop/index.php
Line: 81
Function: include
File: /home/ladysere/public_html/shop/targets/payment_notification.php
Line: 34
Function: include
File: /home/ladysere/public_html/shop/include/common/payment_notification.php
Line: 38
Function: include
File: /home/ladysere/public_html/shop/payments/cc_processors/paypal.php
Line: 82
Function: fn_order_placement_routines
File: /home/ladysere/public_html/shop/core/fn_cart.php
Line: 1438
Function: include_once
File: /home/ladysere/public_html/shop/core/fn_sms.php
Line: 6
Function: db_get_field
File: /home/ladysere/public_html/shop/core/fn_database.php
Line: 94
Function: db_query
File: /home/ladysere/public_html/shop/core/db_mysql.php
Line: 89
Function: db_debug_error

Please help, I'd love to get this mod working.
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 31 May 2007 - 01:27 PM #33

that has nothing to do with this mod: your payment id gets lost somewhere
in the transaction as it seems.......
maybe someone here has a clue, or have a look at paypal issues....

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 31 May 2007 - 01:59 PM #34

Thanks for the reply! I guess I thought it was this mod because when I remove it paypal works correctly again.

I'll keep looking. Maybe I have mods interfering with each other.
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 01 June 2007 - 07:36 AM #35

that is odd then. keep us informed.

 
  • techman
  • Senior Member
  • Members
  • Join Date: 12-Sep 07
  • 115 posts

Posted 15 November 2007 - 11:24 AM #36

Is there any updates coming out for this cool mod? I will really love to see it work with 1.3.5
TechMAN,
No one knows it all, help others to help yourself

Advertise your site in Style - Free web Link Exchange
Web Bid Directory - Get Listed Now

 
  • fardin
  • Junior Member
  • Members
  • Join Date: 13-Jan 08
  • 3 posts

Posted 14 January 2008 - 08:58 AM #37

First of all ,Hello all .I just joined the club and in process of installing my 1st CS-Cart .

how can I have a look at this module ?
The link "http://cscart-sms.mediacenterweb.com/" doesn't work

 
  • nwsco
  • Senior Member
  • Members
  • Join Date: 12-Sep 06
  • 372 posts

Posted 14 January 2008 - 09:48 AM #38

the domain mediacenterweb is currently offline: i will move it (later today)
to http://cscart-sms.deplek.com/
(i will also change main post and my sig later with this)

furthermore, i do not have any plans for upgrading it to 1.3.5, since i dont use/have installed 1.3.5 and am very tight in time.
Anyone else is welcome to of course to do so.

 

Posted 14 January 2008 - 10:48 PM #39

Does this support .au mobile providers ?

 
  • gugga7
  • Senior Member
  • Members
  • Join Date: 16-Mar 08
  • 277 posts

Posted 04 April 2008 - 06:55 AM #40

It is really too bad this Mod does not work for 1.3.5 SP2, are you planning a release for this version anytime soon?