vTiger can't find created database

Dec 25 - 16:59 GMT
Customer

Hi Servage
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

Dec 25 - 17:08 GMT
Support - Shelly

Hello Andreas,

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

Dec 25 - 17:26 GMT
Customer

Hi Shelly

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/

Dec 25 - 18:01 GMT
Support - Shelly

Hello Andreas,

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

Dec 26 - 02:24 GMT
Customer

Hi Shelly Thanks

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

Dec 26 - 02:33 GMT
Customer

Hi Shelly

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

Dec 26 - 03:54 GMT
Servage - Steven

Hello Andreas,

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

Dec 26 - 04:12 GMT
Customer

Hi Steven

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

Dec 26 - 04:23 GMT
Customer

Hi Steven

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

Dec 26 - 04:25 GMT
Servage - Steven

Hello Andreas,

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

Dec 26 - 04:41 GMT
Customer

Oh Yeah

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

Dec 26 - 04:43 GMT
Customer

Here the link to the manual

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

Dec 26 - 04:50 GMT
Servage - Steven

Hello Andreas,

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

Dec 26 - 04:59 GMT
Customer

I just checked

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

Dec 26 - 05:06 GMT
Customer

It took us long to achieve the right vTiger settings you just destroyed ;-)

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

Dec 26 - 05:22 GMT
Servage - Steven

Hello Andreas,

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

Dec 26 - 06:37 GMT
Customer

Hi

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

Dec 26 - 07:46 GMT
Customer

HI SERVAGE

Dec 26 - 07:49 GMT
Customer

HI SERVAGE

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

Dec 26 - 07:57 GMT
Servage - Bob

Hello Andreas,

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

Dec 26 - 08:16 GMT
Customer

NO CHANGES AT ALL

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

Dec 26 - 08:27 GMT
Servage - Bob

Hello Andreas,

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

Dec 26 - 09:07 GMT
Customer

https://phpmyadmin-srv1.servage.net/phpMyAdmin/

Dec 26 - 09:25 GMT
Customer

WHEN can we create Tables in the databases???

It takes meanwhile the whole day this problem and we can't proceed.
Andi

Dec 26 - 09:33 GMT
Customer

MAGENTO Database the same ERROR

https://phpmyadmin-srv1.servage.net/phpMyAdmin/index.php?server=5&target=main.php&token=679707be6823682e6d5f19e781c47e33

Dec 26 - 09:35 GMT
Customer

Same ERROR with the TYPO3 Database for t3log.org

https://phpmyadmin-srv1.servage.net/phpMyAdmin/

Dec 26 - 09:40 GMT
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!!!

Nor the owner, nor can we delete them!

Andi

Dec 26 - 09:42 GMT
Customer

When you try to rename the symlink -typo3/typo3_src then it is copying this file to 1typo3_src, 2typo3_src, 3typo3_src

Dec 26 - 09:50 GMT
Customer

Please delete the symlinks called *typo3_conf

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

Dec 26 - 09:51 GMT
Customer

UPDATE vTIGER:

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 ---

Dec 26 - 10:10 GMT
Support - John

Hello Andreas,

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

Dec 26 - 11:53 GMT
Customer

Hi John

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

Dec 26 - 11:55 GMT
Support - John

Hello Andreas,

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

Dec 26 - 12:17 GMT
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