What is this? tables real prefix instead of {prefix}

[TurXaliM]

Hello every body,
I'm newbie + My English isn't been;
What is this
What is this my tables real prefix instead of {prefix}

I haven't working this query :(

INSERT INTO `{prefix}config` (`id_group` , `name` , `value` , `multiple_values` , `type` , `description` , `order` )
VALUES ('1', 'google_map', '', '', 'textarea', 'Google Maps', '300');

[TurXaliM]

What i will put for prefix :s ?

[Dave Baker]

Hello TurXaliM,
Instead of {prefix} you should specify your prefix for database tables of your directory. By default in installation process script uses v2102_ prefix. You can check your prefix in includes/config.inc.php, try to find code like this:

define("DBHOST", "localhost");
define("DBNAME", "dbaker");
define("DBUSER", "dbaker");
define("DBPASS", " :) ");
define("PREFIX", "v2102_"); // it will be your prefix
define("DBPORT", "3306");

OR
You can use code with {prefix} instead of your actual prefix in Admin Panel » Manage Database » SQL Management

[TurXaliM]

I get always this error;

Query Failed:
Table 'txmeurot_txmtlist.{v2102_}config' doesn't exist

[Dave Baker]

You should use prefix {v2102_} without braces. Only v2102_.
Your code should look like this:

INSERT INTO `v2102_config` (`id_group` , `name` , `value` , `multiple_values` , `type` , `description` , `order` )
VALUES ('1', 'google_map', '', '', 'textarea', 'Google Maps', '300');

[TurXaliM]

Ahh, thanks you very much.
Done :)

[Dave Baker]

You're welcome TurXaliM!