Knowledgebase
Home » Item #814
My site generates errors when I put the valid license code into it
Question
I have just received the new CactuShop code via the upgrade system and installed it on my site after upgrading the database. It worked initially, but then when I set the license number in the config.asp from the default to my actual license number, I started getting errors.
For example, on the back end I get a syntax error in this query:
SELECT LANG_SkinLocation, LANG_EmailTo, LANG_EmailToContact, LANG_EmailFrom FROM tblCactuShop1Languages WHERE LANG_ID =
Why is this and how can I fix it?
Answer
Each time a CactuShop page is run, some code checks to see if the config settings exist as application variables (values held in server memory). If they do not exist, CactuShop creates them by running through the config values held in the tblCactuShopConfig table of the database. These application variables are given a name that includes the license number of your CactuShop.
If you have recently upgraded to a new version of CactuShop, there will probably be some new config settings required. However, when you start up CactuShop after upgrading, it detects that config settings for this store already exist and therefore does not rebuild the config settings. This means your store lacks some config settings and hence errors occur.
Many users experiencing this report that everything was fine after upgrading until they changed the license number from the default to their correct license number. This is because the store detected that no config settings existed named after the default license number and so built a new set of config application variables. Being a new set, and not lacking any of the new values, the store consequently worked correctly.
To fix the problem:
A server reboot or IIS restart will cause the config settings in memory to be rebuilt and will cure the problem. Config settings are also rebuilt when you edit and submit any config setting value from the back end of CactuShop. However, because you may not be able to restart the server or Access the back end without errors, we have included another way to force the config settings in your store to be rebuilt. You can pass the following to any page (front or back end):
?appvar=reset
For example,
default.asp?appvar=reset
Once done, this should not need to be repeated as the config settings will be rebuilt correctly after any restart of the server.