Common errors and problems

1. I get errors during setup that tell me index creation failed on some database tables: "CREATE INDEX mimrecidx ON mgw_instmsg (recipient) Access denied for user: 'myusername@localhost' to database 'mydatabase'". Setup fails due to this. What can I do?
2. I get something like "The script tried to execute a method or access a property of an incomplete object". What should i do?
3. I get something like "Warning: Smarty error: problem writing '/home/mlogemann/public_html/moregroupware/templates_c/contact_list.tpl.php.' in /usr/local/lib/php/Smarty.class.php on line 1081". What should i do?
4. My server is located in a different timezone. How can I cope with this?
5. I changed the date/time display settings, but Calendar2 doesn't use them. Why?
1.

I get errors during setup that tell me index creation failed on some database tables: "CREATE INDEX mimrecidx ON mgw_instmsg (recipient) Access denied for user: 'myusername@localhost' to database 'mydatabase'". Setup fails due to this. What can I do?

The best way would be to ask your system administrator why you dont have CREATE INDEX rights on your database. Alternatively you can delete the CREATE INDEX lines from the end of modules/general/setup/install.sql, and run setup again. Then it will speed up things if you create the indexes manually (either though phpMyAdmin or directly with "ALTER TABLE <tablename> ADD INDEX ( <fieldname> )").

2.

I get something like "The script tried to execute a method or access a property of an incomplete object". What should i do?

Make sure that session_auto_start is disabled in php.ini!

3.

I get something like "Warning: Smarty error: problem writing '/home/mlogemann/public_html/moregroupware/templates_c/contact_list.tpl.php.' in /usr/local/lib/php/Smarty.class.php on line 1081". What should i do?

You have a problem with the rights on the folder "templates_c" or "templates_wml_c". Just give the right "write others" to this folder (on file system level) and the problem should be solved. You should of course check your security rules whether this is the best way to do it.

4.

My server is located in a different timezone. How can I cope with this?

You can add:

	  putenv ('TZ=Australia/Hobart');
	  

at the end of your config.php, e.g.

	  putenv ('TZ=Australia/Hobart');
	  ?>
	  

The different timezones can be found on a normal linux server at: /usr/share/zoneinfo (safe_mode needs to be off in php.ini). In our tests on WindowsXP there were some working zones and some failing, but on Linux all worked fine.

For more information take a look at: http://de.php.net/putenv.

5.

I changed the date/time display settings, but Calendar2 doesn't use them. Why?

Calendar2 uses the language files for displaying the dates and times. The params are explained at: http://www.php.net/date. The language files can be found at: modules/calendar2/lang/calendar2.*.lang (* is the country shortcut). These lines should be interesting for you (german settings for a time like 14:10):

timeFormat = H:i
timeFormat_small = H:i

H means 24 hours, i means minutes. English settings for a time like 2:10 p.m.:

timeFormat = g:i A
timeFormat_small = g:i

g means 12 hours, i means minutes, A means am or pm.