Here's the error:



    * user warning: Table 'thecrazy_drupal.ec_transaction_product' doesn't exist query: SELECT vid FROM ec_transaction_product WHERE txnid = 2 in /home/thecrazy/public_html/includes/database.mysql.inc on line 167.
    * user warning: Table 'thecrazy_drupal.ec_transaction_product' doesn't exist query: INSERT INTO ec_transaction_product (txnid, nid, vid, title, price, qty, data) VALUES('2', '207', '207', 'Test Shippable Product', '10.00', '1', 's:0:\"\";') in /home/thecrazy/public_html/includes/database.mysql.inc on line 167.

Comments

vikingew’s picture

vikingew commented
Status: Active » Fixed

This is fixed in dev release. Also it doesn't make sense to report fresh bugs for an old release, you should at least update to the latest stable first. However, in this case it doesn't differ as this was fixed after release of 5.x-3.3

Anonymous’s picture

Anonymous (not verified) commented

Actually, I have the latest 5.2 (the release: from the Drupal home page link) and the latest e-commerce (from the download link: from home page > modules > e-commerce). Am I missing something?

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Postponed (maintainer needs more info)
vikingew’s picture

vikingew commented
Version: 5.x-3.0 » 5.x-3.3

Doug Ouverson wrote "Am I missing something?"

Yes, according to your issue you are running Version 5.x-3.0, but according to your follow up response you are not. This is my point, it may look minor but the developers invest their free time in this and the least we users can do is to supply them with proper info so they don't need to waste time start looking at the wrong place. I set this to 5.x-3.3 as I think that's what you are running and leave it as Active for now. I suggest you give some better info though as by just supplying an error message w/o any context info doesn't inspire to help. Then we might can conclude for sure if this is fixed in dev or not.

This is not aimed for you, but it just pisses me off when there is a nice and simple guide line at top of the bug form, saying "Don't mark the issue as HEAD" and still people do (as an example). I think it's plain ignorance and lack of respect for the individuals giving of free will for our service. Well I have stated my point.

Anonymous’s picture

Anonymous (not verified) commented

I appreciate your points, but understand mine - I DON'T KNOW WHAT VERSION I'M RUNNING; I explained in my follow-up information regarding my download(s). I looked under: administer > Status report: just says "Drupal 5.2"; I looked in the Drupal 5.2 download, and again, "Drupal 5.2".

Instead of lecturing me, maybe you could tell me where to find the version, so I/we can fix this bug?

Humbly....

Anonymous’s picture

Anonymous (not verified) commented

My bad.

I don't report issues that much and misunderstood; I understand now that you were looking for the e-commerce version, and not the Drupal version....

Yes: 5.x-3.3

brmassa’s picture

brmassa commented
Status: Postponed (maintainer needs more info) » Fixed

Doug,

its problems generally is created when users not install all eC core modules or try to install them all at once. on the next version, eC4, we fixed this issue by installing all needed modules automatically.

Well, try to UNINSTALL every eC module (disable first them unistall it) and start the process again. Note that ALL modules on "e-Commerce Core" group must be installed, except subproducts. Also, you will need to install at least one payment gateway. It worked for almost all people on same issue.

best regards,

massa

PS: im gonna mark it as fixed, but fill free to change it in case of further questions

Anonymous’s picture

Anonymous (not verified) commented

Thank you for helping me.

I actually tried what you recommended, but it seems that the database tables need to go as well, or that that seems to be the issue.

What I did was this:
1.) I disabled the eC modules 1-by-1 as the modules would allow (some had to be disabled before other could be).
2.) I then removed eC from the sites/all/modules/contrib directory
3.) I ran the update.php file and also checked to see if eC was in the "uninstall" tab (which it wasn't)(actually, I checked the "uninstall" tab first).
4.) I started all over again.

Is this the process? What order to I enable eC components?

brmassa’s picture

brmassa commented

Doug,

yes, some modules on eC3 were not correctly unistalling their databases so you have to:

1* Delete all "ec_" tables on your database
2* Delete all "ec_" variables on varibles table
3* Finally, delete all eC modules from system table.

(no need to delete the eC files.)

reinstall one at time.

regards,

massa

Anonymous’s picture

Anonymous (not verified) commented

Could you please share commands for doing the following:

2* Delete all "ec_" variables on varibles table
3* Finally, delete all eC modules from system table.

I got the tables deleted, but am having troubles doing the last 2, and the reinstall doesn't seem to be working w/o doing these 2....
Thanks - Doug

smikey’s picture

smikey commented

Hi Doug -

Have you used phpmyadmin before? You can find the necessary tables fairly easy from this application. After locating them, it should be fairly straight forward on how to modifiy them. Thanks..

Michael

Anonymous’s picture

Anonymous (not verified) commented

Couldn't you share commands - please. I don't use phpmyadmin. I work almost exclusively from the command-line; a habit I got into a couple of years ago. Thanks.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Postponed (maintainer needs more info)
brmassa’s picture

brmassa commented
Status: Postponed (maintainer needs more info) » Fixed

Doug,

administrate databases with PHP is a breeze: install PHPMyAdmin. its much much easier.

regards,

massa

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
reg’s picture

reg commented

I had the same problem, with 3.3, however I decided to be a little more surgical about it and run the CREATE SQL for the table rather than enable/disable a whole bunch of modules. Is there any reason this problem can't be corrected by just executing the following:

      CREATE TABLE ec_transaction_product (
        txnid int(10) unsigned NOT NULL default '0',
        nid int(10) unsigned NOT NULL default '0',
        vid int(10) unsigned NOT NULL default '0',
        title varchar(128) default NULL,
        price decimal(10,2) NOT NULL default '0.00',
        qty int(10) unsigned NOT NULL default '0',
        data text,
        UNIQUE KEY txnid (txnid,nid),
        KEY txnid_2 (txnid)
      ) TYPE=MyISAM;