Thursday, December 27, 2007

MYSQL PHPMYADMIN ERRORS

Dec 26 - 13:07 GMT
Customer
We can't create tables in MYSQL Databases

The Databases are not found by the applications

i.e. vtiger.
http://apapococ.blogspot.com/2007/12/vtiger-cant-find-created-database.html

The same errors apply to all databases

Magento database
vTiger Database
TYPO3 Database
Redmine Database

Only database working at the moment is the one for the lifetype installation on www.t3log.com

PLEASE CHECK YOUR SERVER SETTINGS AS SINCE 5 F I V E Days we get stuck because of those Database Problems.

We tested the vtiger on another server and there it is working with the same settings we have in your installation.

We need all Databases working in 2 Hours as we have to get the sites finished until tomorrow GMT +7

Andi
Dec 26 - 13:13 GMT
Servage - Julie
Hello Andreas,

As far as I found the database connection at lifetype/config/config.properties.php is perfect. The connection details for LifeType database is properly set.

I need the particular URL where you are getting database not found error.

Thank you.

Kind regards,
Julie, Support Team Member
Servage Hosting
Dec 26 - 15:32 GMT
Customer
There are 5 databases and 4 are NOT working so please don't discuss the one I already told you in a former thread that ONLY lifetype is working. This is really unprofessional help.

As there are 4 databases
the one from vtiger, the one from typo3, the one from magento and the one from redmine which aren't able to CREATE a table.

Simply try with OUR permissions to create a database
open it in phpmyadmin and try to create a TABLE

RESULT: YOU CAN'T

THE WHOLE DAY went lost because of this actual very simple to solve problem by changing our account to the right permissions.

PROBLEM 2

The symlinks mentioned before are still there and have not been deleted. Could you plesase give us SYSADMIN Access so we can delete them by ourselv thanks. OR Change your SERVERSETTINGS so that we can delete SYMLINKS

You can read your former posts in our BLOG
http://apapococ.blogspot.com/2007/12/file-not-deletable.html

Thanks
Dec 26 - 16:01 GMT
Customer
Still the same ERROR

We need to get this SOLVED!!!

How long do we need to wait?
i.e. MAGENTO Database
https://phpmyadmin-srv1.servage.net/phpMyAdmin/
Click on Databases and you will get the ERRORS

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 - 16:05 GMT
Customer
Server: -----.servage.net
Error

SQL query:

CREATE TABLE employees(
id INT( 3 ) NOT NULL AUTO_INCREMENT ,
Lastname VARCHAR( 50 ) ,
Firstname VARCHAR( 25 ) ,
Title VARCHAR( 10 ) DEFAULT 'crew' NULL
)

MySQL said: Documentation
#1046 - No database selected
Dec 26 - 16:14 GMT
Customer
MAGENTO INSTALLATION ON SERVAGE HOSTING

It seems not to be possible to run the php application magento on servage hosting as it is not possible for the application to create even the smallest table. Also the customer itself isn't able to create a table i.e. via phpmyadmin

HOW CAN YOU CREATE A TABLE ON SERVAGE HOSTIN MYSQL DATABASES???
http://www.t3pack.com/install/wizard/config/
ERROR:
Incorrect database name '-----'

Andi
Dec 26 - 16:17 GMT
Customer
UPDATE
REDMINE DATABASE is working now
Server: ----- - Database: -----
LIFETYPE DATABASE is working

All others are NOT working and it isn't possible to create tables there
Dec 26 - 16:21 GMT
Customer
VTIGER INSTALLATION on SERVAGE HOSTING

It seems not to be possible to run the php application vTiger on servage hosting as it is not possible for the application to create even the smallest table. Also the customer itself isn't able to create a table i.e. via phpmyadmin

HOW CAN YOU CREATE A TABLE ON SERVAGE HOSTIN MYSQL DATABASES???
http://www.t3log.net/install.php
ERROR:
The Database "-----" is not found.Try changing the Database settings
Dec 26 - 16:27 GMT
Customer
TYPO3 INSTALLATION on SERVAGE HOSTING

It seems not to be possible to run the php application TYPO3 on servage hosting as it is even not possible to delete the symlink typo3_conf after unpacking the dummy package. This is necessary as ALL TYPO3 Packages will link to the same SOURCE which is placed in xsys As we weren't able to procede because of this problem we weren't able to test the database connectivity. But we guess that it is not possible for the application to create even the smallest table. Also the customer itself isn't able to create a table i.e. via phpmyadmin

HOW TO DELETE SYMLINKS ON SERVAGE HOSTING AFTER UNPACKING FILES/FOLDERS
HOW CAN YOU CREATE A TABLE ON SERVAGE HOSTIN MYSQL DATABASES???
Dec 26 - 16:32 GMT
Customer
Yep tested the typo3 database from phpmyadmin
https://phpmyadmin-srv1.servage.net/phpMyAdmin/
ERROR:
Server: -----
Error

SQL query:

CREATE TABLE employees(
id INT( 3 ) NOT NULL AUTO_INCREMENT ,
Lastname VARCHAR( 50 ) ,
Firstname VARCHAR( 25 ) ,
Title VARCHAR( 10 ) DEFAULT 'crew' NULL
)

MySQL said: Documentation
#1046 - No database selected
Dec 26 - 16:45 GMT
Servage - Sam
Hello Andreas,

Please select the database name before executing any sql statements. It should work. Please try now.

Thank you!

Kind regards,
Sam, Support Team
Servage Hosting
Dec 26 - 16:58 GMT
Customer
Hi Sam

WE ALWAYS SELECT A DATABASE BEFORE WE EXECUTE A SQL we are PROFESSIONALS!!!

Error

SQL query:

CREATE TABLE employees(
id INT( 3 ) NOT NULL AUTO_INCREMENT ,
Lastname VARCHAR( 50 ) ,
Firstname VARCHAR( 25 ) ,
Title VARCHAR( 10 ) DEFAULT 'crew' NULL
)

MySQL said: Documentation
#1046 - No database selected

As you can see here your MYSQL Settings are WRONG!! as it is not recogniozes when we select a Database

A call to DATABASES leeds to the already mentioned error messages. Read our Report about SERVAGE HOSTING in our BLOG - AT The moment it seems that NO APPLICATION IS WORKING AT ALL at SERVAGE HOSTING beside Lifetype! ;-)

You better change the Database settings so that the Databases can be created

Andi
Dec 26 - 17:12 GMT
Servage - Sam
Hello Andreas,

Oh - please create a database without '.'
You created ----- please do not use '.' - you may create ----- [without '.'] and check again/

Thank you! :)

Kind regards,
Sam, Support Team
Servage Hosting
Dec 26 - 17:54 GMT
Customer
STILL ALSO SYMLINK ERRORS

we can not delete Symlinks

1typo3_src

SysAdmin
u--------- Change Settings Delete File

2typo3_src

SysAdmin
u--------- Change Settings Delete File

3typo3_src

SysAdmin
u---------

As you can see here they are all SYSADMIN

/-typo3

PLEASE DELETE THOSE SYMLINKS

/-typo3/1typo3_src
/-typo3/2typo3_src
/-typo3/2typo3_src
/-typo3/typo3_src

-------------------------------------

Then copy and OVERWRITE existing files and folders.

COPY xsite and all its subfolders and files 4 times into the MAIN directory, these will be the TYPO3 installations comming up next, when your databse is accessible again.
Dec 26 - 18:07 GMT
Customer
ditO


No comments: