Coppermine & SQL woes - argh ! please help !

Since Coppermine is the only gallery that will work with safe mode on (as far as I know) it must get it working.

I'm having trouble installing though - after I put the prefix in the install box and hit install all of the queries give me a green light except for the second last one which gives me this:


ALTER TABLE pn_cpg_pictures DROP INDEX search, ADD FULLTEXT search (title,caption,keywords,filename,user1,user2,user3,user4)
mySQL Error: Table 'snl93826.pn_cpg_pictures' doesn't exist


What do I do now ? I don't know anything about MySql and how to create databases/ tables etc. cry



Now if I ignore above error and continue the install I'm getting this:

Warning: main() [function.main]: open_basedir restriction in effect. File(/usr/local/share/pear/modules/coppermine/lang/eng.php) is not within the allowed path(s): (/home/web/snl93826:/var/tmp:/usr/local/lib/php) in /usr/home/web/snl93826/modules/coppermine/include/init.inc on line 226

Warning: main(modules/coppermine/lang/eng.php) [function.main]: failed to open stream: Operation not permitted in /usr/home/web/snl93826/modules/coppermine/include/init.inc on line 226

Fatal error: main() [function.require]: Failed opening required 'modules/coppermine/lang/eng.php' (include_path='.:/usr/local/share/pear') in /usr/home/web/snl93826/modules/coppermine/include/init.inc on line 226


What to do about this one ?


I really hope someone can help me out and give me an idiot proof explanation on what to do now. I'm getting desperate :x