Bind the Order History to a User

Post by ckonig » Tue May 10, 2011 11:09 pm

ALTER TABLE  `order_history` ADD  `user_id` INT( 11 ) NOT NULL ;

Post by spitos » Wed May 25, 2011 12:02 am

I received this error when clicking the edit link on an order:

Error: Unknown column 'oh.user_id' in 'on clause'
Error No: 1054
SELECT oh.date_added, os.name AS status, oh.comment, oh.notify, user.username FROM order_history oh LEFT JOIN order_status os ON oh.order_status_id = os.order_status_id LEFT JOIN user ON (oh.user_id=user.user_id) WHERE oh.order_id = '9' AND os.language_id = '1' ORDER BY oh.date_added

Sounds like a great mod though, any idea on what's wrong?

Would also be great if the time of edit was displayed next to the date (not sure if this does already I can't get it to work )

v1.4.9.5

Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here

Post by ckonig » Wed May 25, 2011 3:02 pm

Post by spitos » Wed May 25, 2011 3:58 pm

No, I didn't, sorry. Can't believe I missed that!

Got it working fine now.

I did make a small change to the xml file so that it reads 'Username' instead of 'column_username' in the admin order history screen.

Changed this:

Code: Select all

			<add>
				<![CDATA[
				$this->data['column_username'] = $this->language->get('column_username');
				]]>
			</add>

To this:

Code: Select all

			<add>
				<![CDATA[
				$this->data['column_username'] = $this->language->get('Username');
				]]>
			</add>

So it now looks like:

Admin view - vQmod Username.jpg (28.39 KiB) Viewed 7802 times

Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here

Post by ckonig » Wed May 25, 2011 4:26 pm

Post by nslim2u » Thu Dec 15, 2011 9:42 pm

Post by ckonig » Fri Dec 16, 2011 6:50 pm

Post by Rainforest » Tue Dec 11, 2012 11:08 am

Self Taught Opencart User & Developer Since 2010.

Post by i2Paq » Thu Dec 13, 2012 10:00 pm

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

Post by Rainforest » Fri Dec 14, 2012 1:20 am

Self Taught Opencart User & Developer Since 2010.

Post by i2Paq » Fri Dec 14, 2012 4:06 am

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

Post by Rainforest » Sat Dec 15, 2012 3:39 am

Self Taught Opencart User & Developer Since 2010.

Post by aljawaid » Mon Nov 23, 2015 1:39 pm

I tried to be clever and convert this to v2.0.3.1 but greatly failed

Total e-commerce newbie bravely testing OC v2.0.3.1 before rolling it live...getting there slowly, somehow. Maybe not. I dunno.