The ghost comments filed in auccount_history_info.php

Trusten · March 2, 2003

The ghost comments filed in account_history_info.php

this is SO strange. account_history_info.ph keeps checking for 'comments', in the order table. in the old shop, this was fine, but in the new shop, it's not.

i have not changed the files, and i looked within the files, it all looks normal, but for the life of me, i CANNOT find where these fields are being called from, you know, like where it would say o.comments, o.customers_name from orders....

i don't know where it's coming from!

HELP!

Ajeh · March 2, 2003

peek in /includes/modules/order_details.php

Trusten · March 2, 2003

Thanks linda, I found it but it wasn't there. It was actually in

includes/class/order.php

was this only my cart or many others?

btw, i'm using your downloads controller, i forgot how to set which status free shippand free payments should take.

:(

Ajeh · March 2, 2003

The instructions in the README.txt tells you which settings are which under the Downloads in the Admin.

As to the class ... that too has references. Depends on what you need to touch as to which file you need to change.

/includes/classes/orders.php or /includes/modules/order_details.php

You have various peices and parts in each file as well as in account_history_info.php itself.

Trusten · March 2, 2003

what i meant with the class file is that in the class/orders.php file, it was asking to select comments from the orders table. in the new Osc, there IS no comments in the orders table.

i don't think it's just me, but alright.

Ajeh · March 2, 2003

Sorry for confusing you ... you are correct the field was moved.

I was just mentioning the places to peek at when looking for things regarding the account_history_info.php file as everything comes from a few different files and sometimes you can get lost in there.

Trusten · March 2, 2003

i see. maybe it's something that should be looked into for the new osc. you won't even know unless you test the order history.

also, for some reason, when i upgraded the database, it shows two fields for 'enable download'. both of them say 'true', but download is no longer working.

i'm about to just pull up my sleeves and rebuild the whole configure table by hand.

:(

god i hate that!

:cry: :cry:

Ajeh · March 2, 2003

Have to be very careful when doing some of the updates ...

Backup everything first is the key to success ... :D

Hmmm ... maybe I should try that myself before updating things ... :shock:

Trusten · March 2, 2003

no luck linda, i just spent like 2 hours remaking the configure table, i can enable download now, but no links show up, AT ALL.

:(

Trusten · March 2, 2003

ok, links are working, and i went into the downloads area of the admin and no luck, I can't get it to work right.

i want that if payment is 0, and shipping is 0, then it lets people download right away. however, if payment is not 0 or shipping is not 0 then it is pending or whatever.

how can i do that?

Ajeh · March 2, 2003

The Downloads Controller v5.3 is designed for that to work with MS1 and a few days to a couple weeks earlier.

Trusten · March 2, 2003

i am using download controller 5_3.

i don't have MS1, i have the dialy shapshot, but you said in your read me that it can work for any osc.

so... i installed it.

:(

i just can't get it to do like it did before. remember you had that file, if 0 zip, but cc, then it would be set to A

if 0 pay but money to ship if they used paypal it would get the status of B.

man, that was a really cool feature.

:(

do i have to uninstall this download controller cuz i don't know how...

Ajeh · March 2, 2003

What I said in the README.txt is ...

While this Add-on was made specifically to work with v2.2 MS1, it should work with any snapshot that has the new individual orders_status settings for the payment modules.

What snapshot do you have?

Trusten · March 2, 2003

:o(

I have the one on feb 25th, pretty recent i'd wager.

i downloaded your download controller the same day....

Ajeh · March 2, 2003

I would think if you compare the files using Beyond Compare, you should be able to see the differences.

Downloads Controller v5.3 was made from the snapshot from either 18th or 19th if I am not mistaken.

All the orders_status settings in the individual payment modules are used to determin what a payment method sets the orders_status to when used in checkout.

This status is what is used by the Downloads Controller.

The settings for what level allows the download to happen is set in Downloads ie 2 and so is the setting that when you Update an order for max days and number of downloads what setting is used buy the Update selection ie 4.

Trusten · March 2, 2003

personally, that ALL went WHOOP, over my head.

could you use baby talk? i've had like 3 hours of sleep....

are you going to look into it? if not, could you just point me in the right direction and give me a kick forward?

thanks much

Ajeh · March 2, 2003

I kinda thought I did look into it ... :shock:

I can install what you have and install Downloads Controller v5.3 and see if it breaks.

Send me your snapshot that you are basing your store on. I sent you a private msg with my email so I don't get the spammer mail by typing it here ... :D

Trusten · March 2, 2003

alright, it's on its way. well, once it finishes scanning...

my anti virus scans them coming and going but you get the idea...

Ajeh · March 3, 2003

I installed snapshot 02-25-2003

Set all my chmod permissions

Compared all files from Downloads Controller v5.3 with snapshot 02-25-2003 - They are all the same

Overwrote with everything in Downloads Controller v5.3

Added to: /catalog/includes/general.php

Added to: /admin/includes/general.php

// BOF: WebMakers.com Added: Downloads Controller

require(DIR_WS_FUNCTIONS . 'downloads_controller.php');

// EOF: WebMakers.com Added: Downloads Controller

Went into phpMyAdmin, loaded downloads_controller.sql

Went into Admin and added a new Order Status called Update that was 4

Checked Configuration ... Downloads ... this was set to Downloads 2 and Update 4

Went into all payment modules ... Changed:

Credit Cards to Processing (2)

Check/Money Order to Pending (1)

Went to the Catalog and created a new account. Note: You cannot add a duplicate account with the same email.

Ordered Unreal Tournament ... paid with credit card ... finished checkout ...

Could not download ... went to Admin and Enabled Downloads ... :shock:

Ordered Unreal Tournament ... paid with credit card ... finished checkout ...

Could now do the download immediately ... :D

Ordered Unreal Tournament ... paid with Check/Money Order ... finished checkout ...

Could not download ...

Went to Admin ... Set order to Processing (2) ... now this could be downloaded ...

Set order to Updated (4) ... this could be downloaded ...

Set order to Pending (1) ... this could not be downloaded ...

Moral of the Story ... Other than remembering to Enable Downloads ... Downloads Controller v5.3 and snapshot 02-25-2003 is 100% compatible and you can just overwrite the files.

Trusten · March 3, 2003

Went into all payment modules ... Changed:

Credit Cards to Processing (2)

Check/Money Order to Pending (1)

i went into my payment and shipping modules and there is nowhere to set these as 'processing' or pending.

i wouldn't try to waste your time like this.

Ajeh · March 3, 2003

When you hit Edit on the payment module there is a setting:

Set Order Status

Set the status of orders made with this payment module to this value

With a dropdown ...

If you do not have these, turn off then on all of your payment modules. It sounds like you have old settings from your payment modules.

And you should do the same on shipping modules.

Be sure if you have any major settings on these to back them up like for Tables or Zones and such so you can put them back in easily.

Trusten · March 3, 2003

ok, got the free charger to work, but no luck with the cc or anything other than the paypal ipn.

at any rate, thank you very much. now i must try to figure out why it's allowing two emails.

do you think it has anything to do with account details?

Ajeh · March 3, 2003

I personally think the issue is a bad MySQL database.

You may be missing updated info, have bad records, duplicates, etc.

I would start with a backup that was clean and working and then slowly start to add the updates in.

Trusten · March 3, 2003

i did, that's the sick part.

i sat down last night all night, took the new database info, and then the old, and put the old 'information', into the new areas and then uploaded only the new sql. it got the downloads working again, that's for sure, but no luck with the cc.

i guess the cc is not that important... :(

at any rate, what about the emails thing, you think maybe it's my editing the account_details.php that is causing it?

Ajeh · March 3, 2003

Have to look where the duplicate is taking place.

If in the checkout_process.php check the bottom of the file where the emails are created and make sure you don't have a duplicate line in there to send.

Also, make sure in your configuration table that you only have one configuration key for the SEND_EXTRA_ORDER_EMAILS_TO

The ghost comments filed in auccount_history_info.php

Recommended Posts

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Trusten

Ajeh

Archived

Browse

Activity