... url_counter);
set url_counter = url_counter + 1;
end while;
END;
|
DELIMITER ;
Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can ...
... the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root".
Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) ...
What?
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this.
How?
Taken from the best forum for programming Qs&As:
http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
...
If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better.
How?
So this is the HOME tab when you open MySQL Workbench. ...
...
Requires:
Web-Based File Manager (eg. cPanel File Manager)
Web-Based Database Manager (eg. phpMyAdmin)
Recommended if you are working remotely as these tend to let you carry out the actions ...
What?
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...
... your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database.
This script will use both databases, reading from the old Joomla database and writing ...
...
The Quick Fix
I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I ...
... sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.