Store credit and reward point module

And what steps are required to completely remove the module, if need be, besides deleting the uploaded files?

I cannot get this to work. If I go to Module Manager and go to list of modules and click on update I get the following error:

"1017 Can't find file: './simetra/SC_CUSTOMER.frm' (errno: 2)
in:
[RENAME TABLE SC_CUSTOMER TO SC_CUSTOMERS;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

I went into myphpadmin and renamed my sc_customer table to sc_customers but same error comes up.

If I go to: Customers > Store Credit I get the following error
1054 Unknown column 'sc.customers_id' in 'on clause'
in:
[select count(*) as total from customers c left join sc_customers sc on c.customers_id= sc.customers_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

How do I fix this???

Fixed it by installing the 3.1 version of store credit

duenorth:

I uploaded the shared class files, the module manager, and v3.01b. But when "installing new module", I got an error relating to not finding table zen_sc_customer. I tried uploading v3.01c files and now I get the error

1017 Can't find file: './[DBNAME]/zen_SC_CUSTOMER.frm' (errno: 2)
in:
[RENAME TABLE zen_SC_CUSTOMER TO zen_SC_CUSTOMERS;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

where [DBNAME] is my database.

The module shows under "list all modules" and now I have access under Modules -> Order Total.

Is that error an issue?
I think the problem is it is adding databases with out the "zen_" on them how to fix it I don't know as I am no SQL expert.

when i try to click on "update"

got same problem

1017 Can't find file: './playscom_zc1/zen_SC_CUSTOMER.frm' (errno: 2)
in:
[RENAME TABLE zen_SC_CUSTOMER TO zen_SC_CUSTOMERS;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

simetra

where is 3.1 version download link?

i only find 3.01b

paranoia: is this a test server? Can you pm me more info?

I'm getting an error:

1146 Table 'zencart.zen_sc_customers' doesn't exist

No idea how to fix it. It seems you have to download files from 4 different locations. It would be nice to have them all packaged together :|

Working on it, actually. Will pack it in one package today or so. The thing is that it uses more than 1 packages, and these packages are developed separately.> paul3648:

I'm getting an error:

1146 Table 'zencart.zen_sc_customers' doesn't exist

No idea how to fix it. It seems you have to download files from 4 different locations. It would be nice to have them all packaged together :|

paul3648:

I'm getting an error:

1146 Table 'zencart.zen_sc_customers' doesn't exist

No idea how to fix it. It seems you have to download files from 4 different locations. It would be nice to have them all packaged together :|

Sorry - I guess I didn't have the latest files. It seems to be working now.

I had the earlier version of Store Credit installed, followed the update instructions.

Is this supposed to preserve existing store credits? Or do I need to write them down before updating?

Working with a test store so no worries so far.

It should reserve all existing store credit.> paul3648:

I'm getting an error:

1146 Table 'zencart.zen_sc_customers' doesn't exist

No idea how to fix it. It seems you have to download files from 4 different locations. It would be nice to have them all packaged together :|

This seems to be working - the credit is shown on the checkout page with the option to apply the credit to the current purchase.

One problem: The sidebox is not showing up. It is showing on the list of sideboxes:

sideboxes/store_credit.php

I've tried turning it off and back on again, but it doesn't show up.

Had to uninstall but had a problem at step 3 of the checkout page

I followed your instruction to uninstall
Get this message and the rest of the page is blank

1146 Table 'shazzas_clothes08.sc_products_ratio' doesn't exist
in:
[SELECT ratio FROM sc_products_ratio WHERE products_id=116 LIMIT 1]

Is there anything I can do to fix this as they keep clicking refresh which dup orders

Any help will be appreciated./

Using Zen Cart 3.8

Oh, did you you remove all the files? Regards. And also, which version you use? While the new version does not over-write any file, the old versions did.

Hi Yellow
Wow! that was a fast reply
Firstly, I for one appreciate your mod, just having probs installing it.
3.01c is the version I used.
I have lost the page for uninstall to check, but I beleive aI followed all instructions
Is there a newer version that I can try and perhaps fix this?

Cheers
Ausjohn

If you need help, pm me your ftp and admin details ^_^. I will go in and fix it for you (Im doing the same thing for many others in order to get all the bugs fixed)

Hi,

I'm trying to install Module Manager on my localhost but encountered the following error:

Fatal error: Cannot redeclare class yclass in C:\Program Files\xampp\htdocs\zen138a\includes\init_includes\init_yclass.php on line 3

btw, I have installed the Advanced cross-sell mod. also by yellow1912 so my init_yclass.php file in C:\Program Files\xampp\htdocs\zen138a\shadmin\includes\init_includes looks like the following (note the red color text):```

<?php require_once(DIR_FS_CATALOG.'includes/init_includes/init_yclass.php'); // added for shared class use by Module Manager. By yellow1912 // y stands for yellow1912 :p. I simply add this to store all the functions frequently used in my mods // PHP4 always pass object by value (default) while PHP5 pass by reference if (version_compare(phpversion(), '5.0') < 0) { eval(' function clone($object) { return $object; } '); } class yclass{ function db_result_to_string($glue, $db_result){ $temp_array = array(); if($this->is_obj($db_result,'queryFactoryResult')){ // We need to clone, because we don't want to touch the real object while(!$db_result->EOF){ $temp_array[] = $db_result->fields['products_'.XSELL_FORM_INPUT_TYPE]; $db_result->MoveNext(); } $db_result->Move(0); $db_result->MoveNext(); } return implode($glue,$temp_array); } // This function does not work for all languages! BEWARE function array_to_upper(&$entries){ foreach($entries as $entry){ $entry = strtoupper($entry); } } // http://us3.php.net/manual/en/function.is-object.php#66370 function is_obj( &$object, $check=null, $strict=true ){ if (is_object($object)) { if ($check == null) { return true; } else { $object_name = get_class($object); return ($strict === true)?( $object_name == $check ):( strtolower($object_name) == strtolower($check) ); } } else { return false; } } } ?>

Stenrique: did you update the whole shared-class as instructed? I think that's where the problem is

Regards

Yellow,

Please HELP!

I don't know what I did but after installing the mod for this I get this error on checkout

1146 Table 'simetrao_zc1.sc_products_ratio' doesn't exist
in:
[SELECT ratio FROM sc_products_ratio WHERE products_id=233 LIMIT 1]

What do I do???

Hi Simetra, did you go to tools->module manager and choose install?

Regards