Ceon Manual Card Payment Module v2.0.0!

[conor]

Hi,

1054 Unknown column 'balance_due' in 'field list'
in:
[UPDATE orders SET balance_due = '1754.75' WHERE orders_id = 1820]

This has nothing to do with Ceon Manual Card. This is code from a custom module you have installed.

Find out which module you have installed that uses a "balance due" field and fix it so that it works with standard Zen Cart payment modules.

Ceon Manual Card's use in this case is simply highlighting/showing you a problem caused by another module. Ceon Manual Card is not part of the problem.

Hope that helps!

Goof luck with your new store!

All the best...

Conor
ceon

[LRS]

Hi,


This has nothing to do with Ceon Manual Card. This is code from a custom module you have installed.

Find out which module you have installed that uses a "balance due" field and fix it so that it works with standard Zen Cart payment modules.

Ceon Manual Card's use in this case is simply highlighting/showing you a problem caused by another module. Ceon Manual Card is not part of the problem.

Hope that helps!

Goof luck with your new store!

All the best...

Conor
ceon

Thanks for the suggestion. I will see if I can figure out which module is using that but I have no idea what it might be or how to find it.

Just curious why everything works fine as long as I remove the Ceon Manual Card module if it has nothing to do with the Ceon module? I have absolutely no clue how to figure out what the problem is other than what I see happening

Ceon installed - checkout crashes when using it for payment at checkout

Ceon removed - checkout works fine with other payment modules.

[LRS]

It looks like it is Super Orders that is the only module with the text balance_due in it.....

I ran the patch for it and so far it seems to be working. Though I did get an error when I ran the patch.

super_orders_sql.sql

Thanks for the help

[conor]

Hi,

Thanks for the suggestion. I will see if I can figure out which module is using that but I have no idea what it might be or how to find it.

Download all the files for your site and search them for "balance_due".. this is NOT part of Zen Cart normally so must be a module you've installed. It's probably some customisation of the orders.php class.

I recommend using ActiveState Komodo's "Find in files" feature for this.

Just curious why everything works fine as long as I remove the Ceon Manual Card module if it has nothing to do with the Ceon module?

This is what's called a "correlation".. something which shows up because of a particular action but is not "caused" by it.

My guess is that another module on your site is messing things up but that only Ceon Manual Card is being used in a way that calls this broken behaviour.

It is indeed this other module that is at fault though.

If you installed other payment modules which take card details you'd most likely have the same problem highlighted by them. There must be something different in the likes of the check/money order module that doesn't cause the broken module/code to be used.

All the best..

Conor
ceon

[conor]

Hi,

It looks like it is Super Orders that is the only module with the text balance_due in it.....

I ran the patch for it and so far it seems to be working. Though I did get an error when I ran the patch.

super_orders_sql.sql

You can see from the eror message itself that you are missing a column in your orders database table, which this other module expects: "balance_due".

That column needs to be added to avoid this problem.. however simply adding the column without finding out what went wrong could be a recipe for further problems. You should find out what failed exactly and repair all the problems.

It would appear that part of the SQL patch failed.. you'll have to undo everything the SQL patch did and get it to run successfully from start to finish, or manually run the bits that didn't work, one by one.

That should probably be easy enough if you know anything about SQL. I'm afraid I can't help you with that on this thread though, helping with third party modules is not covered by the free support offered from Ceon, you should ask on the super orders thread.

All the best..

Conor
ceon

[LRS]

Hi,



You can see from the eror message itself that you are missing a column in your orders database table, which this other module expects: "balance_due".

That column needs to be added to avoid this problem.. however simply adding the column without finding out what went wrong could be a recipe for further problems. You should find out what failed exactly and repair all the problems.

It would appear that part of the SQL patch failed.. you'll have to undo everything the SQL patch did and get it to run successfully from start to finish, or manually run the bits that didn't work, one by one.

That should probably be easy enough if you know anything about SQL. I'm afraid I can't help you with that on this thread though, helping with third party modules is not covered by the free support offered from Ceon, you should ask on the super orders thread.

All the best..

Conor
ceon

Thanks again for pointing me in the right direction.

I will head over to the Super Orders thread and post the error message there.

Everything seems to be working but that error message should be cleared up I presume.

[conor]

Hi,

Thanks again for pointing me in the right direction.

No problem.

I will head over to the Super Orders thread and post the error message there.

It's clearly because of the failure of the SQL patch to run.. search the Super Orders thread before you ask any questions, so as not to use up anyone's time unnecessarily. The end result its likely to be to simply find out where the SQL patch failed and to manually run the commands from that point onwards, adjusting them as necessary to get them to complete successfully.

Everything seems to be working but that error message should be cleared up I presume.

You've got that very wrong indeed! An error message means that things *aren't* working!

Never ignore error messages like this! You wouldn't wait for a car engine to explode rather than attend to an oil light "error message", don't do the same in the digital world! :)

All the best..

Conor
ceon

[LRS]

Hi,
You've got that very wrong indeed! An error message means that things *aren't* working!

Never ignore error messages like this! You wouldn't wait for a car engine to explode rather than attend to an oil light "error message", don't do the same in the digital world! :)

All the best..

Conor
ceon

I didn't mean to imply I was going to ignore the error on the sql patch......though I can see how you might have thought that.

All I meant was that everything I have tested is now working including super orders and the ceon module. I will track down the error on the super orders patch and figure out what is happening there. In the mean time I will simply remove super orders since I need to have my site working in the morning.

I would post the error message but I can't retrieve it since my hosting company is doing an upgraded to php right now (which is the ONLY reason I am upgrading to the latest version of ZenCart) and I cannot access my site at all.

Again, thanks a bunch for your help!

[conor]

Hi,

I didn't mean to imply I was going to ignore the error on the sql patch......though I can see how you might have thought that.

No problem, that did indeed appear to be the case. ;)

All I meant was that everything I have tested is now working including super orders and the ceon module.

By manually adding the missing field? That could be all that is required.. however I wouldn't be comfortable until I 'd made sure that I was sure all the SQL statements in the patch had managed to run succesfully.

I will track down the error on the super orders patch and figure out what is happening there.

Sounds like the right way to go!

I would post the error message but I can't retrieve it since my hosting company is doing an upgraded to php 5.3 right now and I cannot access my site at all.

That's good timing! ;-P

Again, thanks a bunch for your help!

No problem.

All the best..

Conor
ceon

[Forum5]

I manually installed Zen-cart 1.3.9d on HostGator.
When the cart was running, I loaded 10 products from the /store/storeadmin/index.php

http://www.mydomain.com/store/index.php worked
and
http://www.mydomain.com/store/storeadmin/index.php
worked, before I applied the neon Manual Card.


In order to apply the ad-on, I zipped up the entire site less the cache and downloaded it to my computer. I applied the ad-on as per instructions, re-zipped the software and moved it back to the server.
I modified the sql as per instructions.

http://www.mydomain.com/store/index.php executes properly and displays the products properly.

I can not cause:
http://www.mydomain.com/store/storeadmin/index.php to display.

The Admin ‘index.php' will not display when I launch
http://www.mydomain.com/store/storeadmin/index.php
or
http://www.mydomain.com/store/storeadmin/
I rebooted my computer several times, cleaned the cache, cleaned cache from within IE, rebooted several more times, waited 24 hours and it still will not execute. I changed permissions to 775 on includes/configure.php and storeadmin/index.php and still no luck. The contents of configure.php was not altered since it was working before the ad-on.

I don't know what the problem is.
Is there something in the ad-on that is loaded when admin/index.php executes that is causing the problem? Maybe I copied something to the wrong folder?

Do I have to remove everything and reinstall the entire cart? Just what's up?

I have a copy of the previous software install backed up and could revert to that and test agn but I thought I would give a shout out first.

Has anyone run into a situation like this?