DB Error: Bad SQL Query: SELECT setting_name, setting_value

[Vivek]

Dear friends,

I am new to 4images , trying to install 4images first time , but seems something wrong in my attempt, if any one can help me to sort it out.

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table '*****_images.4images_settings' doesn't exist
ERROR: Could not load configuration settings!

I am trying to install 1.7.6 latest available for download.

whats wrong ??

Regards,
Vivek

[Vivek]

You can check error on my demo domain.

[mawenzi]

welcome Vivek to 4images forum,

... as the message said, your '4images_settings' table doesn't exist ... I don't know why ...
... so, if it is a fresh installation ... delete all files and db tables ... and try a new installation ...
... I think, it is the fastest way for a 100% working 4images installation ...

[Vivek]

welcome Vivek to 4images forum,

... as the message said, your '4images_settings' table doesn't exist ... I don't know why ...
... so, if it is a fresh installation ... delete all files and db tables ... and try a new installation ...
... I think, it is the fastest way for a 100% working 4images installation ...

Thanks mawenzi,

but i like to say , i had been try to re-install 3 time before starting a thread , using wordpress , so i do this thing first , infact after first failure , i re-download whole folder upziped it and upload in different folder) still getting same answer

[mawenzi]

... your setting table name is not ... 'C********s.4images_settings' ... !
... I don't know why you use such a name ...
... but check your db and table names via phpMyAdmin ...
... and your config.php for $table_prefix = "4images_"; ...

[V@no]

During 4images installation, did 4images say it installed database successfully?

Did you create a new database with the name of "C242092_images" ? (this is done via your host's ACP)

[Vivek]

... your setting table name is not ... '*****_images.4images_settings' ... !
... I don't know why you use such a name ...
... but check your db and table names via phpMyAdmin ...
... and your config.php for $table_prefix = "4images_"; ...

I don't have much knowledge of phpMyAdmin , but when i check through phpMyAdmin , i found "No tables found in database." in Structure tab.

@mawenzi , please remove user name starting with "C****" from your previous post and V@no post for my security

[Vivek]

During 4images installation, did 4images say it installed database successfully?

Did you create a new database with the name of "*****_images" ? (this is done via your host's ACP)

No sir , after upload , when i click the link , i got this error.

I have created new database for 4images.

[mawenzi]

@mawenzi , please remove user name starting with "C****" from your previous post and V@no post for my security

... done ...

[V@nо]

what link you are referring to?
when 4images can't find config.php it automaticaly installation process, where you enter all needed information for you database

[Vivek]

what link you are referring to?
when 4images can't find config.php it automaticaly installation process, where you enter all needed information for you database

no i manually edited config.php details, is it the problem ??

i edited than uploaded the file. I have not enter any info direct on webpage , what i done till now is,

I downloaded 4images 1.7.6
unzip it.
Edited the username, host, password in config.new.php file and rename it to config.php
uploaded it to my server.

than click to my domain

now please tell me anything wrong , i did in this steps

[Vivek]

In config.new.php file , i edited following link and renamed it to config.php

$db_servertype = "mysql";
$db_host = "myhost";
$db_name = "Database Name";
$db_user = "Database User";
$db_password = "PASSWORD";

$table_prefix = "4images_";

define("4IMAGES_ACTIVE", 1);

[V@nо]

there we go, found the problem. config.php means nothing if database is not installed.
delete config.php from the server and start installation process. once 4images finished installing database it will try create config.php, if it fails saving the file, it will offer you download it, no file editing required.
more info about installation process you can find in docs/installation.txt

[Vivek]

hip hip hurry ,its done

I edited the file as we do it in wordpress , first edit than upload , thanks for solving the matter.


Thanks V@no

[Vivek]

one question , how can i disable new registration ??


and which template this website is using ??

http://www.moviegupshup.net