Tutorials

Build up your database

Requirements

PHPCG analyzes your database intelligently.
To obtain the best results, it is necessary to follow good practices:

  • The database name, table names & fields names:
    • *must use only lowercase/uppercase alphanumeric characters and underscores
      (no hyphens, spaces or special characters)
    • *must NOT start with a number
  • *Each table must have a primary key
  • **Relationships between tables must be correctly defined
  • **Field types must match expected values

* Absolutely required
** Highly desirable


MySQL Workbench

MySQL Workbench is the official software released by MySQL team

MySQL Workbench allows you to build your databases simply, and synchronize them with your server

Once installed and connected with your server, you will benefit from a reliable and efficient tool.

Main features:

  • Create/Edit/Delete tables & fields
  • Create Diagrams using drag and drop
  • Create foreign keys and relationships from diagrams using drag and drop
  • Synchronize with your server database
  • Save & export to several formats

Soon Coming Complete video tutorial about MySQL Workbench


FlySpeed SQL Query

FlySpeed SQL Query is is a Free SQL Query Tool developed by Active Database Software

The visual query designer facilitates the creation of complex SQL queries.

It can be especially useful for creating advanced filters using external relations.

Below is an overview of what FlySpeed SQL Query can do for you:

FlySpeed SQL Query Screenshot

Soon Coming Complete video tutorial about FlySpeed SQL Query


Register changes in your database structure

Work in progress


How To

Installation/Registration

Reinstall PHPCG

If for some reason you have to reinstall PHPCG, you must:

  1. Delete install/install.lock to unlock th installer
  2. Open install/do-install.php in your browser,
    enter your license code & click the "uninstall button

Once done, you can reinstall PHPCG at the same place or somewhere else.


Admin Panel

Edit admin Forms code

Work in progress


Edit admin Lists code

Work in progress


Translate date & time

  • Translate date & time in admin lists:
    1. Open /conf/user-conf.php
    2. Replace Locale::setDefault('en_EN'); with your own language code
  • Translate date & time in admin forms (pickadate plugin):
    1. Duplicate pickadate.xml from /class/phpformbuilder/plugins-config/ to /class/phpformbuilder/plugins-config-custom/
    2. Open /class/phpformbuilder/plugins-config-custom/pickadate.xml
    3. Find the <custom-date> tag, uncomment <file>pickadate/lib/compressed/translations/fr_FR.js</file> and replace fr_FR.js with your own language code.
      The language file must exist in /class/phpformbuilder/plugins/pickadate/lib/translations/

Troubleshooting

Installation

Error - Not Acceptable!

Not Acceptable! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [...]

This error is generated by Apache mod_security

It means that your server Firewall (mod_security) is configured to block some requests for security reasons.

You have to allow the request manually, and the correct way to do this depends on your server itself.

A Google search may help.

If not, contact your server provider and ask for help. Give him the datetime you encountered the error and the url, it'll help him to help you.


Cannot connect to licensing server

You probably entered a wrong purchase code.