I can't run those commands in PHPMyAdmin SQL queries tab. I changed "CREATE
DATABASE" to CREATE DATABASE IF NOT EXISTS that went fine. Then GRANT ALL..
gives an error:
1044 - Access denied for user 'lsi'@'localhost' to database 'lsi_alloc'
Well i skipped this part because I already set all the privileges in cpanel
when i created the database and database user.
Then i tried SOURCE command line and it gives me this error:
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SOURCE /home/lsi/public_html/alloc/installation/db_structure.sql' at line 1
What am i doing wrong?.. if I click on AllocPSA installation part 4 "test
database connection" it says database connection test succesful. Then if I
just click install database I get this page full of errors.
I tried to find the solution from internet or same error but i could not.. And
I have spend hours for this.. I would be so happy if someone can help me. I am
not that good with databases etc.. But I have been installing many PHP apps
like Vtiger etc to same hosted server.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you SOOO much Alex.. I managed to install. The only thing what happened
was that when importing db_triggers.sql i got this error but the installation
passed still and i just managed to sign in. Just checking out if everything is
working fine.. and once more Thank You.
) ) THEN INSERT INTO auditItem( entityName, entityID, personID, dateChanged,
changeType, fieldName, oldValue )
VALUES (
entityName, entityID, personID(
), NOW( ) , "FieldChange", fieldName, oldValue
);
END IF ;
END $$
MySQL ilmoittaa:
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'log(entityName VARCHAR(255), entityID INTEGER, fieldName VARCHAR(255),
oldValue ' at line 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
Please can someone help me with this: I cannot get past this AllocPSA
installer part 3..
DROP DATABASE IF EXISTS lsi_alloc;
CREATE DATABASE lsi_alloc;
GRANT ALL ON lsi_alloc.* TO 'lsi_alloc'@'localhost' IDENTIFIED BY
'passwordhidden';
FLUSH PRIVILEGES;
USE lsisfi_alloc;
SOURCE /home/lsi/public_html/alloc/installation/db_structure.sql;
SOURCE /home/lsi/public_html/alloc/installation/db_data.sql;
SOURCE /home/lsi/public_html/alloc/installation/db_constraints.sql;
SOURCE /home/lsi/public_html/alloc/installation/db_triggers.sql;
I can't run those commands in PHPMyAdmin SQL queries tab. I changed "CREATE
DATABASE" to CREATE DATABASE IF NOT EXISTS that went fine. Then GRANT ALL..
gives an error:
1044 - Access denied for user 'lsi'@'localhost' to database 'lsi_alloc'
Well i skipped this part because I already set all the privileges in cpanel
when i created the database and database user.
Then i tried SOURCE command line and it gives me this error:
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SOURCE /home/lsi/public_html/alloc/installation/db_structure.sql' at line 1
What am i doing wrong?.. if I click on AllocPSA installation part 4 "test
database connection" it says database connection test succesful. Then if I
just click install database I get this page full of errors.
I tried to find the solution from internet or same error but i could not.. And
I have spend hours for this.. I would be so happy if someone can help me. I am
not that good with databases etc.. But I have been installing many PHP apps
like Vtiger etc to same hosted server.
Hi there,
When it says SOURCE /home/lsi/public_html/alloc/installation/db_structure.sql
what it means is that you should import
the db_structure.sql file into your database. I believe phpmyadmin may allow
you to upload an sql file to import.
You will need to do that for each of the four files that are SOURCEd.
Kind regards,
Alex Lance
http://allocpsa.com
Thank you SOOO much Alex.. I managed to install. The only thing what happened
was that when importing db_triggers.sql i got this error but the installation
passed still and i just managed to sign in. Just checking out if everything is
working fine.. and once more Thank You.
SQL-kysely:
CREATE PROCEDURE LOG( entityName VARCHAR( 255 ) , entityID INTEGER, fieldName
VARCHAR( 255 ) , oldValue TEXT, newValue TEXT ) BEGIN IF( neq(
oldValue,
newValue
) ) THEN INSERT INTO auditItem( entityName, entityID, personID, dateChanged,
changeType, fieldName, oldValue )
VALUES (
entityName, entityID, personID(
), NOW( ) , "FieldChange", fieldName, oldValue
);
END IF ;
END $$
MySQL ilmoittaa:
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'log(entityName VARCHAR(255), entityID INTEGER, fieldName VARCHAR(255),
oldValue ' at line 1