Customer
Hi ServageDec 25 - 17:08 GMT
The Database "---" is not found.Try changing the Database settings
This Error message am I receiving when I run theinstall of vtiger.
I only pasted and copied all data from your configuratio files. Thanks
Andi
Support - Shelly
Hello Andreas,Dec 25 - 17:26 GMT
Please ensure that you use the datasource/servername as
'mysql1054.servage.net' in your installation configuration file.
If you are still facing problem please let us know the url where you are facing this problem so that we can review and let you know with the updates.
Thank you :)
Kind regards,
Shelly, Servage - Support
Servage Hosting
Customer
Hi ShellyDec 25 - 18:01 GMT
That's the fac I am already using it:
The Database "---" is not found.Try changing the Database settings
Database Configuration
Host Name ---
User Name ---
Password ********
Database Type mysql
Database Name ---
Site Configuration
URL http://www.t3log.net
-----------------
Can you please check what's wrong there thanks
Andi
Path /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/
Cache Path /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/cache/
Support - Shelly
Hello Andreas,Dec 26 - 02:24 GMT
Please fill in the database information in the db config file and then give us the following information:Name*
Email ID*
Contact Number (optional)
Comments
so that we can test the installation and let you know with the updates.
Thank you :)
Kind regards,
Shelly, Servage - Support
Servage Hosting
Customer
Hi Shelly ThanksDec 26 - 02:33 GMT
It is cTiger Version 5.0.3 patched for use with PHP5.2 and up
Here are the data you will need:
---------------
Name: Andreas Becker
email: ab.becker-web.de
Contact Number: +66816063378
Comments: Just testing again (We had Installation Problems)
---------------
The comments part is only needed as the registration went already through with them at the last installation, so that they don't think its two separate installations.
ATTENTION:
IT MUST BE UTF8!!!
The database tables NEED to be UTF8 too!!!
check the one I already created
AS I CAN SEE IT AT THE MOMENT THERE IS A PROBLM WITH YOUR DATABASES AND NOT WITH VTIGER!!!
---------
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
-----------------------
It is not possible to change the collation of the TABLES before installing the tables. This will cause that all tables will be in this stupid latin1_swedish_ce set either then being UTF8_UNICODE_CE
!! CHECK IT FIRST !!
If you install vTiger BEFORE Changing the collation settings for all tables to utf8 then the complete vTiger installation is worthless for us as then everything will be latin1_swedish_ce what is WRONG!!
Chokdee which means good look in trying and Merry Christmas!
Andi
Customer
Hi ShellyDec 26 - 03:54 GMT
Just tried to create a new database but same result:
ERROR in PHPMYADMIN while calling "Databases"
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
----------------------------------
If you need to create a new database to get vTiger running then please delete the vTiger:
---
and
---
and recreate
---
Description
vTiger_t3log.net
Thanks
Andi
Servage - Steven
Hello Andreas,Dec 26 - 04:12 GMT
Well, I have done some changes. Also set the configuration details properly according to the database '---'. So, please try again. And do not forget to provide the proper database details while checking the 'System Configuration' during the installation.
Hope this helps!
Kind regards,
Steven, Support
Servage Hosting
Customer
Hi StevenDec 26 - 04:23 GMT
Now I can't access the page at all http://www.t3log.net or http://t3log.net
Both times those errors show up:
Warning: chmod() [function.chmod]: Operation not permitted in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php on line 80
Warning: chmod() [function.chmod]: Operation not permitted in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php on line 80
Warning: chmod() [function.chmod]: Operation not permitted in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php on line 80
Warning: chmod() [function.chmod]: Operation not permitted in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php on line 80
Warning: chmod() [function.chmod]: Operation not permitted in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php on line 80
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php:80) in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/index.php on line 79
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php:80) in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/index.php on line 84
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php:80) in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/index.php on line 84
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/log4php/appenders/LoggerAppenderFile.php:80) in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/index.php on line 93
----------------
Please check
Andi
Customer
Hi StevenDec 26 - 04:25 GMT
The Error message has changed to
Warning: require_once(log4php/LoggerManager.php) [function.require-once]: failed to open stream: No such file or directory in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/include/logging.php on line 25
Fatal error: require_once() [function.require]: Failed opening required 'log4php/LoggerManager.php' (include_path='.:/usr/local/lib/php/') in /mounted-storage/home81c/sub004/sc44977-AQJR/-vtiger/include/logging.php on line 25
But still no access
Andi
Servage - Steven
Hello Andreas,Dec 26 - 04:41 GMT
Well, seems some specific permission is needed for the folder "/-vtiger/log4php". can you please check the permission for this folder at the software end? As we can not find out the specific permission it needed. So, please consult once at the software vendor.
Hope this helps!
Kind regards,
Steven, Support
Servage Hosting
Customer
Oh YeahDec 26 - 04:43 GMT
You just produced a very unsecure worst case scenario. Never set 777 everything needs to stay like it is when delivered from vTiger. Can you please change all settings back. It took hours to get them there ;)
then specific folders and files need to be accessible by the webserver!!! this is much more secure then 777.
Thanks
Andi
Customer
Here the link to the manualDec 26 - 04:50 GMT
And you can read here also about the problematic setting things to 777.
http://wiki.vtiger.com/index.php/Vtiger_CRM_5.0.3_-_Installation_Manual_for_Linux#Installing_vtiger_CRM_Source
Andi
Servage - Steven
Hello Andreas,Dec 26 - 04:59 GMT
Well, may I request you, please upload the file once again and try? Unfortunately I can not find where to change the permission. Though you can do it by yourself too.
Thanks!
Kind regards,
Steven, Support
Servage Hosting
Customer
I just checkedDec 26 - 05:06 GMT
The problem is still the DATABASE and PHPMYADMIN as it is showing still the same errors. IT IS NOT vTiger you need to correct first. First of all you need to solve the problem in seen in phpmyadmin as even phpmyadmin is not able to show the EMPTY database of vtiger. Therefore it isn't even possible to create ANY table in this database. We had the same problem yesterday with lifetype.
We had to work with a workaround - which worked in lifetype but unfortunately not in vtiger.
In lifetype we had this procedure to achieve the utf8 settings.
Step 1 create the lifetype database
Step 2 run the lifetype installation just after the point where the database gets created but simply abort this process as soon as it started
Step 3 go to phpmyadmin of lifetype database
Step 4 DROP all tables of lifetype DATABASE
Step 5 Set collation of all Tables (as now this function will be available and wasn't before!!!) to utf8_unicode_ci
Step 6 Start again the Installation Process from the point where you need to enter the database settings and press on create database.
---------
ONLY THEN all tables have been created in utf8 and lifetype is running now fine as a multiblog subdomainblog setting.
PLEASE DON't TOUCH the lifetype DATABASE!!!
This was only an example!!
---------
In vTiger this procedure is not working as vTiger isn't creating any tables at all and therfore not starting the process like in lifetype. In other words here we don't have this workaround to solve the PHPMyAdmin and MySQL UTF8 Problem.
So please reinstall vTiger. (you can find all tarballs in xtar) then patch it - this will take you faster back to the right settings then changing your settings back to where they were!
Then apply the settings mentioned in the manual of vTiger I send you the link for.
Next enter the data I send to you and try to create the database.
You will be able to reproduce the error.
Now go to phpmyadmin and try to CREATE at least ONE table - This will not be possible. SO NOW START solving THIS PROBLEM first, as if the database isn't working proberly how can the application?
Thanks for doing this
Andi
Customer
It took us long to achieve the right vTiger settings you just destroyed ;-)Dec 26 - 05:22 GMT
In Linux shell use the following command:
#Never chmod 777 for security reasons, at the parent directory of vtiger, chown apache:root directoryname -R (This will change the owner of all sub folders and directories to apache and root. All directories and files should have the correct access, If not use chmod to set the access, more information can be found with "man chmod" for access permissions
1. You must have READ/WRITE permissions on the following vtiger CRM folders and Files within those folders:
* PHP Configuration - config.inc.php
* Cache Directory - cache/
* Mail Merge Template Directory -test/wordtemplatedownload/
* Uploads Directory - storage/
* Install Directory - install/
* Installation file -install.php
* Product Image Directory -test/product/
* User Image Directory - test/user/
* Contact Image Directory- test/contact/
* Logo Directory- test/logo/
* Email Templates Directory -modules/Emails/templates/
* User Privileges Directory - user_privileges/
* Smarty Compile Directory - Smarty/templates_c
* Tabdata File Permission - tabdata.php
* ParentTabdata File Permission - parent_tabdata.php
* Smarty Cache Directory - Smarty/cache
2. Your php.ini must configured with the following parameters:
* safe_mode = Off
* display_errors = On
* file_uploads = On
* register_globals = Off
* max_execution_time = 600
* output_buffering= On
* memory_limit = 32M
* error_reporting = E_WARNING & ~E_NOTICE
* allow_call_time_reference = On
* log_errors = Off
* short_open_tag= On
* extension=php_gd2.dll
* extension=php_imap.dll
* extension=php_mysql.dll
* extension=php_mysqli.dll
Servage - Steven
Hello Andreas,Dec 26 - 06:37 GMT
Well, while further checking, I got the file 'config.inc.php' is blank. And secondly could not find any issue with the phpmyadmin. So, I am requesting you, please try once again uploading file and follow the exact procedure.
Thanks!
Kind regards,
Steven, Support
Servage Hosting
Customer
HiDec 26 - 07:46 GMT
I setup a NEW Database and get STOCK just after creating
It is NOT POSSIBLE to create ANY TABLE in this database
It is NOT POSSIBLE to call DATABASES >> ERROR
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Database Ascending
Total: 1
PLEASE CORRECT YOUR SETTINGS!
We are getting time problems as we are meanwhile working on this since days.
PLEASE ALSO CHECK the REDMINE Thread as YOU need to execute this command like written by Servage before. I need to continue work for ---- and therfore this is needed and VERY IMPORTANT!!!
Andi
Customer
HI SERVAGEDec 26 - 07:49 GMT
Customer
HI SERVAGEDec 26 - 07:57 GMT
We need to temporarily close this ticket BUT IT IS STILL NOT SOLVED
We need to close as you customer service has changed permissions of all folders and files without prior checking for the real problem mentioned - phpmyadmin Creating Tables not [possible]
Therefor we need now to reinstall complete vTiger as your customer service isn't able to switch back to the previous - already configured version of vTiger.
We will get back as soon as the Database Problem is solved in the next Thread
Andi
Servage - Bob
Hello Andreas,Dec 26 - 08:16 GMT
I've made some changes, please check now.
If still you will face same problem then please get back to us. We are here to help you.
Thank you!
Kind regards,
Bob, Support
Servage Hosting
Customer
NO CHANGES AT ALLDec 26 - 08:27 GMT
Databases
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 225
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /www/public/phpMyAdmin-2.10/server_databases.php on line 313
Servage - Bob
Hello Andreas,Dec 26 - 09:07 GMT
Sorry to hear about the problem you are facing.
But, please provide us the exact url where you are getting this error. As the domain http://www.t3log.net/ is working fine at our end.
Thank you!
Kind regards,
Bob, Support
Servage Hosting
Customer
https://phpmyadmin-srv1.servage.net/phpMyAdmin/Dec 26 - 09:25 GMT
Customer
WHEN can we create Tables in the databases???Dec 26 - 09:33 GMT
It takes meanwhile the whole day this problem and we can't proceed.
Andi
Customer
MAGENTO Database the same ERRORDec 26 - 09:35 GMT
https://phpmyadmin-srv1.servage.net/phpMyAdmin/index.php?server=5&target=main.php&token=679707be6823682e6d5f19e781c47e33
Customer
Same ERROR with the TYPO3 Database for t3log.orgDec 26 - 09:40 GMT
https://phpmyadmin-srv1.servage.net/phpMyAdmin/
Customer
Hi We are not able to create a symlink to -typo3/typo3_src as this file is SYSADMIN and we can't change them!!!Dec 26 - 09:42 GMT
Nor the owner, nor can we delete them!
Andi
Customer
When you try to rename the symlink -typo3/typo3_src then it is copying this file to 1typo3_src, 2typo3_src, 3typo3_srcDec 26 - 09:50 GMT
Customer
Please delete the symlinks called *typo3_confDec 26 - 09:51 GMT
we can't continue!!!
Current path: /-typo3
Parent Folder
fileadmin
You
drwxr-xr-x Protect Change Settings Delete File
typo3conf
You
drwxr-xr-x Protect Change Settings Delete File
typo3temp
You
drwxr-xr-x Protect Change Settings Delete File
uploads
You
drwxr-xr-x Protect Change Settings Delete File
1typo3_src
SysAdmin
u--------- Change Settings Delete File
2typo3_src
SysAdmin
u--------- Change Settings Delete File
3typo3_src
SysAdmin
u--------- Change Settings Delete File
clear.gif
46B
You
-rw-r--r-- Change Settings Delete File
index.php [edit]
SysAdmin
u--------- Change Settings Delete File
INSTALL.txt [edit]
6.92KB
You
-rw-r--r-- Change Settings Delete File
README.txt [edit]
7.51KB
You
-rw-r--r-- Change Settings Delete File
RELEASE_NOTES.txt [edit]
425B
You
-rw-r--r-- Change Settings Delete File
t3lib
SysAdmin
u--------- Change Settings Delete File
typo3
SysAdmin
u--------- Change Settings Delete File
typo3_src
SysAdmin
u--------- Change Settings Delete File
_.htaccess [edit]
4.93KB
You
-rw-r--r-- Change Settings Delete File
Customer
UPDATE vTIGER:Dec 26 - 10:10 GMT
We get stuck at the same DATABASE PROBLEM as already this morning!!!
The Database "---" is not found.Try changing the Database settings
Database Configuration
Host Name ---
User Name ---
Password ********
Database Type mysql
Database Name ---
Support - John
Hello Andreas,Dec 26 - 11:53 GMT
Please note that I have just checked and found that DB --- under the "MySQl Databases" option in your control panel. May I know where you are getting the error " The Database "---" is not found" so that I can check it further.
Kind regards,
John, Servage - Support
Servage Hosting
Customer
Hi JohnDec 26 - 11:55 GMT
Simply SCROLL DOWN to the very first POST before more then 1 day!
I am getting this error when i open phpmyadmin and click on Databases.
ANY DATABASE!!!
Andi
Support - John
Hello Andreas,Dec 26 - 12:17 GMT
I have checked the phpmyadmin for "--- and found that no tables are there. You need to import your .sql file in order to populate the tables.
Kind regards,
John, Servage - Support
Servage Hosting
Customer
HA HA HA
Sorry - better you read the whole post before answering. Exactly THIS is the problem I even can't create a table in the database. Nor can I set the collation for tables before importing data into the tables.
The steps for importing are:
1. Creating the database
2. Changing the collation for Tables to utf8 (This is necessary because of the stupid setting in your server for latin1 as default)
If you would change the default setting from latin to utf8 I could import right the way but so I need first to set the right collations to utf8 otherwise all tables will be latin1 and we will have a complete type missmatch.
Try to create a table in phpmyadmin and set the collation of the tables to utf8_unicode_ci THEN we can import. If you are able to do this from an account like mine then fine - let me know HOW
Andi