Skip to main content

​THE INTERVIEWEE WHO HATED ME​

6 years ago a guy looked at me face to face, and boldly told me; "I don't like you!" I immediately fired a response, I asked him that day; "Thank you for the honest feedback, but those that you like, how has it made their life better? How does your liking people pay their bills or take a bank loan? My brother keep your like, I need God's like And that's what guarantees my future. Today I joined a CEO friend of mine in an interview Panel to recruit some new staff, it was a long session, as we returned from a coffee break to continue the hectic interview session, here was this same guy walked in with his grey jacket and CV coming for the interview. Our eyes kissed by fluke, we immediately recognised each other; "the world is indeed spherical", I soliloquized. He felt very uncomfortable through out the interview, one could clearly see the volcanic eruption ongoing in his whole nervous system, he even mistook his date of birth for his last date of empl...

All About Opencart: Add table prefix in mysql database for opencart

All About Opencart: Add table prefix in mysql database for opencart:
Shared:::

Add table prefix in mysql database for opencart

If you ever install an opencart without table prefix, you'll get troubles when using some custom modules. (Especially with the table ORDER, RETURN and OPTION. Because that is same as MYSQL Syntax., you'll get error when calling such as "SELECT * FROM ORDER")

Here is what you do to add prefix on the table.

Enter the database you want to change the table prefix.

put below command in SQL Tab and run it. Just change the RED one. Example : my_prefix_ into oc_
and my_database into yourdatabasename

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_',TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema ='my_database'
run it in SQl Tab in PHPMyadmin.
Copy the results. (Don't forget click Show All, to see all result) and select it from top to bottom using your mouse, and copy it.
Paste it on the notepad first.

and remove these 3 row from the list.
ALTER TABLE option RENAME TO oc_option; (rename manualy)
ALTER TABLE return RENAME TO oc_return; (rename manualy)
ALTER TABLE order RENAME TO oc_order; (rename manualy)
if you put this on below list, it will get error. You'll have to rename it manually one by one. Not using SQL Tab.

Copy the list (list table may vary, don't use my result list, use your result list) because i already delete some lines, because it's to long.
ALTER TABLE address RENAME TO oc_address;
ALTER TABLE affiliate RENAME TO oc_affiliate;
ALTER TABLE affiliate_transaction RENAME TO oc_affiliate_transaction;
ALTER TABLE attribute RENAME TO oc_attribute;
ALTER TABLE attribute_description RENAME TO oc_attribute_description;
ALTER TABLE attribute_group RENAME TO oc_attribute_group;
ALTER TABLE attribute_group_description RENAME TO oc_attribute_group_description;
...
ALTER TABLE url_alias RENAME TO oc_url_alias;
ALTER TABLE user RENAME TO oc_user;
ALTER TABLE user_group RENAME TO oc_user_group;
ALTER TABLE weight_class RENAME TO oc_weight_class;
ALTER TABLE weight_class_description RENAME TO oc_weight_class_description;
ALTER TABLE zone RENAME TO oc_zone;
ALTER TABLE zone_to_geo_zone RENAME TO oc_zone_to_geo_zone;
Copy the list put it on SQL Tab Box and run it.
there you go. please refresh it if you don't see the result changes. just change between database, and back again. you will see all your tables already have a prefix on it.
Don't Forget to manually rename the 3 tables (OPTION, RETURN and ORDER), don't use SQL you'll get error.
First Select the table, then click OPERATIONS Tab,  
Table options
Rename table to
Rename it to oc_order. (example). That's it. 
Thank you for reading. Hope it'll help you.

Comments

Popular posts from this blog

​THE INTERVIEWEE WHO HATED ME​

6 years ago a guy looked at me face to face, and boldly told me; "I don't like you!" I immediately fired a response, I asked him that day; "Thank you for the honest feedback, but those that you like, how has it made their life better? How does your liking people pay their bills or take a bank loan? My brother keep your like, I need God's like And that's what guarantees my future. Today I joined a CEO friend of mine in an interview Panel to recruit some new staff, it was a long session, as we returned from a coffee break to continue the hectic interview session, here was this same guy walked in with his grey jacket and CV coming for the interview. Our eyes kissed by fluke, we immediately recognised each other; "the world is indeed spherical", I soliloquized. He felt very uncomfortable through out the interview, one could clearly see the volcanic eruption ongoing in his whole nervous system, he even mistook his date of birth for his last date of empl...

Canton Jones - Hallelujah ft. Deitrick Haddon, DPB,

Mercury Mail Configuration in Windows

My friend talked of writing stuff people look for to make it interesting. Not just people. He said.  i write stuff I would like to read.  I really looked for this. I searched alot. Am sharing because it helped me alot.  The Mercury Mail package in xampp for windows is a great way to start sending emails from openemr or any open source CMS program placed in xampp. The configuration is easy, just need to follow the steps: Benefits of Mercury Mail in openEMR Easy to setup and integrated with XAMPP package Appointment reminders will be sent automatically using Batchcom/Automatic_notification via cronjob The patient reminder mails(alert reminders) will be sent automatically Secure Obtaining Mercury Mail If not using XAMPP, but still want to use mercury mail, you can get it from here http://www.pmail.com/downloads_s3_t.htm Steps of Configuration 1. After downloading Mercury Mail and installing it or if using Xampp, you can find it in C:/x...

Imagine - John Lennon and The Plastic Ono Band (with the Flux Fiddlers)

Lauren Daigle - O' Lord (Radio Version)

You're Bigger by Jekalyn Carr (Live Performance) Official Video

Eulogy | How could you leave us?

I feel this.The only difference is mine is a dad, minus pills. I lost my dad. Hard to keep up  with. Thanks for a place to let it out. Hard to keep it in. Harder to tell a story. Just write down what you're thinking n feeling +Patrick   (not everything though)  Can't use a past tense..I love my dad. I told my dad I loved him once, and it felt awesome. Had never done. I've never told my mum that I love her. I think I need to. I felt so bad...I've never wanted the news bearer to be as wrong as that day. I thought of praying and raising the dead, but just couldn't do it. Science said no, God let it happen. He has reasons. Can't question. NF kinda painted it for me. Honestly, some things can't be forgotten. Can't be undone. Can't be replaced. The only thing I have are precious last moments and advices. Specifically the last thing I did is share a cup of tea in my room. If you're watching Dad, I'm not looking back. I'm matching forth...

Skillet - Set It Off [Official Audio]

rsync

rsync is a software application for Unix systems which synchronizes files and directories from one location to another while minimizing data transfer using delta encoding when appropriate. An important feature of rsync not found in most similar programs/protocols is that the mirroring takes place with only one transmission in each direction. rsync can copy or display directory contents and copy files, optionally using compression and recursion. The rsync utility uses an algorithm (invented by Australian computer programmer Andrew Tridgell) for efficiently transmitting a structure (such as a file) across a communications link when the receiving computer already has a different version of the same structure. The recipient splits its copy of the file into fixed-size non-overlapping chunks, of size S, and computes two checksums for each chunk: the MD4 hash, and a weaker 'rolling checksum'. It sends these checksums to the sender. The sender then compares its ...