Jump to content

[Solved] mysql db problem


saaddp

Recommended Posts

When i create a Mysql db using MySQL Databases

it does creates the database (visible in phpmyadmin) but for some reason i cant see the database in the mysql databases window

resulting in that i cant add users to the database

i tried clearing cache and stuff but it just doesnt work

 

even now i have 2 databases created but i cant see them though they are visible in phpmyadmin

 

my domain is oblivionguild.co.cc (if admins need to check it)

 

tnx in advance :unsure:

 

Screenshots

1st one shows mysql databases

second one shows phpmyadmin

 

 

EDIT:

oh and i have used cpanel before and used Filezilla to connect to the file manager storage

for some reason its not letting me connect to it :X

i m a newbie at this so if possible kindly tell me how to set up ftp storage account and how to access it via an ftp client

 

EDIT2:

same for subdomains

i made the subdomain but its not appearing on the list

is that cpanel bug or mine ? i tried different browsers

pruned cache

even tried a different pc with diff internet but still buggit

 

EDIT3:

every now and then it gives me 500 internal server error

sometimes it says wait 24hours account queued :S

this is starting to annoy me now :(

Link to comment
Share on other sites

and now i m getting this error in phpbb3 acp (which wasnt happening before)

 

General Error

SQL ERROR [ mysqli ]

 

Got error 28 from storage engine [1030]

 

SQL

 

SELECT l.*, u.username, u.username_clean, u.user_colour FROM phpbb_log l, phpbb_users u WHERE l.log_type = 0 AND u.user_id = l.user_id ORDER BY l.log_time DESC LIMIT 5

 

BACKTRACE

 

FILE: includes/db/mysqli.php

LINE: 163

CALL: dbal->sql_error()

 

FILE: includes/db/mysqli.php

LINE: 205

CALL: dbal_mysqli->sql_query()

 

FILE: includes/db/dbal.php

LINE: 170

CALL: dbal_mysqli->_sql_query_limit()

 

FILE: includes/functions_admin.php

LINE: 2597

CALL: dbal->sql_query_limit()

 

FILE: includes/acp/acp_main.php

LINE: 536

CALL: view_log()

 

FILE: includes/functions_module.php

LINE: 507

CALL: acp_main->main()

 

FILE: adm/index.php

LINE: 74

CALL: p_master->load_active()

Link to comment
Share on other sites

Same here, my wordpress installation gets down since it can't access to their wp database. The MySQL users also dissapeared. In phpmyadmin works great all. Also I've got the problem while loading the cpanel, i've got the blank page. I just use a workaround for it, just changing .php to .html in the web address after logging it. Hope you have no problem fixing it. Until then, I will make a database backup, just in case. Greetings!

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...