[eluser]zimco[/eluser]
I had my CI application working on my localhost osx platform running apache2, php-5, mysql-5 and then uploaded it to my hosted webserver running Apache version 1.3.41 (Unix), PHP version 5.2.5, MySQL version 4.1.22-standard and i keep getting this error for a database query:
Code:
A Database Error Occurred
Error Number: 1142
SELECT command denied to user 'myhostprefix_manager'@'localhost' for table 'race_events'
SELECT event_results.event_id, `horse_name`, SUM(`score`) AS totalscore, `score` FROM (`event_results`) JOIN scores.race_events ON event_results.event_id = race_events.event_id WHERE scores.race_events.gait = 'Pace' GROUP BY `horse_name`
I created a mysql user via mysql adminstation in the Cpanel and set it's privileges to ALL, yet for the above particular SELECT command i keep getting this error but other mysql queries within the same CI application on the same database work perfectly fine.
I've contacted the webhost company and they say "We're looking into this" and i've never heard from them again.
So, does anybody have any suggestions on what i could do to get the above query to work on the hosted platform? Or does the 4.1.22 version of mysql not allow a join as i have written it? Or is it the webhost mysql privilege settings that i have no control over?