Hi! I downloaded a free version of aMember off of your website. I've managed to install it on my own domain as a test (the web manager is cpanel), however, I've been having difficulty installing it on another domain. It has to be installed through phpMyAdmin, the only problem is, it gives me the following error: -- MySQL said: You have an error in your SQL syntax near '@amember@access_log ( log_id int(11) NOT NULL auto_increment, member_id int(11' at line 1 --
This is an error in mysql: If you want to install the database through phpMyAdmin you will have to alter the database as Alex has stated at the start of the SQL file as follows: # WARNING! If you want to apply it manually # REPLACE @DB_MYSQL_PREFIX to desired value - # possible empty string This means that: CREATE TABLE @DB_MYSQL_PREFIX@access_log will become: CREATE TABLE amember_access_log amember_ is the prefix.
I create the database in phpMyAdmin with my hosting panel, and use the installer to populate the fields ... just fill in in the info that the installer asks ie localhost:databasename:usernameassword and there is nothing else to do.