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

Rudimental - These Days feat. Jess Glynne, Macklemore & Dan Caplen [Offi...

Pretty depends on which side you're at. . .

Canton Jones - Hallelujah ft. Deitrick Haddon, DPB,

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

Marriage | Whatsapp forward

MARRIAGE....... He was having his evening beverage That's when she joined him. "Hi there handsome, you're looking good. So fine I can eat you up" she said sitting down. "I thought we agreed to keep away from each other? I am a married man" he told her. " Come on. I won't bite. You can't resist me, no man can" she said. "I am a married man" he told her. "Fight all you want, but soon I will have you. I am way better than your wife" she told him. "You are nothing compared to my wife" he told her off. "Really? All this body. All these curves. All these sweetness. I bet your wife is not as good in bed as I am" she told him unbuttoning the top button of her blouse to reveal her cleavage, then lifting up her skirt, just a bit. "If I was a lustful and unfaithful man, all that would move me. But I am too grown to be enticed by what you're showing off. I am a grown man, you think all that consumes

Lecrae Kills It!!

Please don't have weird imaginations..you need to checkout out this.. Andy Mineo Ripping em apart... Check it out

Christmas and all - WELCOME TO MOMBASA

 Dear Kenyans (Sana sana Nairobians) who will be coming down to Mombasa for the December holidays: 1. We people who live in Mombasa live in houses. Our homes. 'Hatulalangi' kwa ma hoteli so stop with the 'Nakuja kesho. Ni hoteli gani poa?' Imagine unaeza Google 'Hotels in Mombasa' but we can refer you to a few holiday homes and villa owners who do short term rentals (I'll do another post on this.) 2. If you happen to be looking for transportation, number za JamboJet, Modern coast, Mash, Dreamline are also on Websites. 3. Unless you are really close with someone, do not expect them to hire a car for you ndio upige lap nayo. Hata kama unajilipia. Most of you end up binge drinking and fucking up cars mnaacha watu wakisumbuka. 4. Most Coasterians like Nairobians have schedules. Biryani is mostly a Friday dish after a long week and Friday prayers. Usianze kupiga simu Monday saa tatu asubuhi ati, 'Nipeleke nikakule biryani.' No please. 6. Ugali

Lauren Daigle - O' Lord (Radio Version)

A little Wait

"A certain gentleman walked into a hotel and after perusing through the menu ordered for some food. After about 20 mins another group of gentlemen walked in and ordered for theirs. To his dismay,the first gentleman saw them get served first. He watched as they began to eat and laugh heartily. He even overheard one of them brag about how he knew everyone at that hotel and how things moved fast for him there. He felt he was being mocked.He contemplated leaving. But he had waited soo long. Unable to take it anymore, he called the waiter and spoke rather verbosely of how unfair things were. The waiter calmly told him, yours is a special order sir, being prepared by the chief chef himself. Their orders were prepared hurriedly by interns because the top chefs are busy with yours. That's why they came first. Please have some juice as you wait. Unknown to him the owner of the hotel (who happened to be an old long lost friend of his) had seen him coming and wanted to surprise hi