I had a difficult time trying to install opensis onto my website in order to have an online platform instead of one that is MacOS or Windows dependent. Here is the following stats on my hosting server with ICDSoft (which is great btw) for they tried to install it without success.
Operating software: Linux OS
Database: MySQL 5.0.6
Using the install wizard that the program has, I followed these steps.
Step 1 of 5: I entered the following:
Password: (entered my MySQL password - which I know 100% is correct)
The install accepted these inputs and sent me to Step 2 of 5.
Since my hosting company only allows to create databases via control panel, I did so and entered the name on Step 2. I received an error stating that a database by that name already exist. I thus, tried to use a different name at that step and received the following error probably do to the fact that my hosting company does not allow programs to create databases for security purposes:
Access denied for user 'bhfarm'@'%' to database 'bhfarm_sis'
Therefore, I then tired to install opensis manually via the instructions of INSTALL.txt. I followed instruction carefully and then upon trying to go "/install/reset_autp_increment.php" of my website, I got the following error:
Access denied for user 'bhfarm'@'%' to database 'opensis'
Thus I never got to Step 3 of 5 and etc. I even tried to do the upgrade installer but when I get to Step 2 of 3, no databases are listed even though they do.
Also, while trying to install the .sql file into my database manually the file "opensis-4.5-procs-mysql.sql" installed successfully, however, the .sql file "opensis-4.5-schema-mysql.sql", did not and I received the following error:
SQL query: Documentation
CREATE VIEW TRANSCRIPT_GRADES AS SELECT s.id AS school_id, mp.mp_source, mp.marking_period_id AS mp_id, mp.title AS mp_name, mp.syear, mp.end_date AS posted, rcg.student_id, sms.grade_level_short AS gradelevel, rcg.grade_letter, rcg.weighted_gp AS gp_value, rcg.unweighted_gp AS weighting, rcg.gp_scale, rcg.credit_attempted, rcg.credit_earned, rcg.credit_category, rcg.course_title AS course_name, sms.cum_weighted_factor AS cum_gp_factor, (
sms.cum_weighted_factor * s.reporting_gp_scale
) AS cum_gpa, (
sms.sum_weighted_factors / sms.count_weighted_factors
) * s.reporting_gp_scale
) AS gpa, sms.cum_rank
FROM STUDENT_REPORT_CARD_GRADES rcg
INNER JOIN MARKING_PERIODS mp ON mp.marking_period_id = rcg.marking_period_id
AND mp.mp_type = 'semester'
INNER JOIN STUDENT_MP_STATS sms ON sms.student_id = rcg.student_id
AND sms.marking_period_id = rcg.marking_period_id
INNER JOIN SCHOOLS s ON s.id = mp.school_id;
MySQL said: Documentation
Any suggestions on how to fix this would be wonderful.
Thank you for your time.