Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /home/cedep/public_html/apc-aa/sql_update.php3 on line 82

update=

APC-AA database update script

APC-AA database update

This script is written to be not destructive. It creates temporary tables first, then copies data from old tables to the temporary ones (tmp_*) and after successfull copy it drops old tables and renames temporary ones to right names. Then it possibly updates common records (like default field definitions, APC-wide constants and templates).

However, it is strongly recommended backup your current database !!!

Something like:
mysqldump --lock-tables -u cedep_lhuacho -p --opt cedep_cedep > ./aadb/aadb.sql

 APC-AA database update options
Update DB structure
create or update database structure
Copy current data
copy data from current database to the updated one
Backup current tables
left the current tables in database named like bck_xxx
Refresh APC-wide categories
updates APC-wide (parent) categories
Refresh other constants
updates Codepage constants, Language constants, Bin constants
Redefine field defaults
Updates field templates, which is used when you adding new field to slice
Redefine slice templates
Updates only slice templates, which is in standard AA installation
Add new view templates
Templates for javascript, constans, discussions views, ... you can see in 'ActionApps Core' slice. If you haven't defined any view of some type, the templates are used as default values for new views.
Overwrite existing templates
Check this, if you want overwrite existing view templates with new ones. Default is not to overwrite (unchecked)
Add statistic fields (fix)
New fields (display_count, disc_count, disc_app) in v1.8 should be added to all slice definitions
Add item id fields (fix)
Add 'id' and 'short_id' definitions to fields tabl for each slice, where the definition is missing. It allows searchbar in Item Manager to create filter also on Short id field, ...
Fix missing fields fields
Add missing mandatory fields in slices (status_code.....)
Update modules table
AA version >2.1 supports management not only slices, but other modules too. Module table holds IDs of modules (just like slice IDs), which should be copied from module tables (table slice). The default site and poll module is also created/renewed with this option.
Add entries to Cron
Alerts, cross server networking and database optimization are run by cron.php3, their entries are added to table cron if not yet there.
Add generic email templates
These are examples of each email type.
Add Links module
Before you can use Links module, you have to prepare database for it (create root category). This option create root category if it is not set already.

Write to database
Check this for real work with writing to database

Before you write the data into database, please check if following data are correct. If not, please correct it in config.php3 file.
AA http domain: /
AA image path: /apc-aa/images/
AA doc path: /apc-aa/doc/
Administrator's e-mail: webmaster@my.domain.org
5 characters of database password
Fill in first five characters of the database password (see DB_PASSWORD in config.php3 file) - it is from security reasons