Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

10 posts by 3 authors in: Forums > CMS Builder
Last Post: February 9, 2016

Hi,

If you have experience with mySQL you could run a mySQL command to prepend the field to add 0.

This could be done via phpMyAdmin or using the MySQL Console Add-On here:

http://www.interactivetools.com/add-ons/mysql-console/

Be sure to make a complete backup of your database first. And if you have a staging environment,  that would be preferred.

---------------------------------------------------
Cheers,
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

I have ZERO experience with mySQL. Any step-by-step assistance with this will be greatly appreciated. Thank you.

By Damon - November 11, 2015 - edited: November 11, 2015

Hi,

Step-by-step mySQL instructions isn't something we can provide via support. And with no mySQL experience I would strongly recommend against running any mySQL updates on a live site. 

We can help make the update through our consulting department.  Email the site details to consulting@interactivetools.com and we can provide you a quote.

---------------------------------------------------
Cheers,
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

I just sent an email to consulting@interactivetools.com concerning this. Please let me know if it was received and the next step in getting this sorted out. Thank you.

Hi there.

This is Ross in consulting. Just wanted to let you know I haven't seen your email yet.  Could you check on your end to see if it's stuck in an outgoing mail box or maybe just send another one?

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Resent from another email address. khayam.trinicarsforsale@gmail.com

Hi Arif

Thanks for sending the email again. I got this one and replied to it already.

We can continue the conversation via that email thread.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Apparently some of my emails are not going through. I sent a response. Let me know if you got it. Thank you.

Thanks for the heads up.  Looks like our emails are coming through fine.  We can continue the conversation via email moving forward.

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/