#1146 - Table 'apache.theme_configuration' doesn't exist

[Guest]

Hello,

I assume this is a real easy fix, since i don,t really have a clue here but i am trying to install my first contribution.

Here is my version info;

 

[root@cent]# mysql --version

mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0

 

PHPMYADMIN VERSION;

phpMyAdmin - 2.11.9.3

 

PHP 5.0

osCommerce VERSION;

define('PROJECT_VERSION', 'osCommerce Online Merchant v2.2 RC2a');

 

I am plugging my way along trying to learn mysql with Google on my left and -phpmyadmin on my right. Installing InfoBox_Admin v2.25

# Adds the function to select 'left' / 'right' from a

# radio box so we don't have to use the keyboard too much...

# Add new function colum

 

ALTER TABLE theme_configuration >>>>>>>>>>>(I have no table called theme_configuration, or at least that i can see)<<<<<<<<<<<<<

ADD set_function varchar(255) NULL DEFAULT 'tep_cfg_select_option(array(\'left\', \'right\'),';

 

# Define the function to all rows

UPDATE theme_configuration SET set_function = 'tep_cfg_select_option(array(\'left\', \'right\'),';

>>>>>>>>>>>#1146 - Table 'apache.theme_configuration' doesn't exist <<<<<<<<<<<<<<<<<

 

I named my store database "apache" (obvious I know)

 

Plus, am i supposed to do something with this line, i have tried to run it without success.

UPDATE SQL 2.24 to 2.25

=============

>>>>>>>>>>>>for use set_function to edit 'left' and 'right' :<<<<<<<<<<<<<<<<<<<<<<<,

(update by Thomas Schittli 31.7.2006)

 

Error

SQL query:

FOR USE set_function TO edit 'left' AND 'right'

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for use set_function to edit 'left' and 'right'' at line 1

 

I know I should learn a lot more about SQL commands, rest assured I am trying.

Any help is appreciated.

[Guest]

Hello,

I assume this is a real easy fix, since i don,t really have a clue here but i am trying to install my first contribution.

Here is my version info;

 

[root@cent]# mysql --version

mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0

 

PHPMYADMIN VERSION;

phpMyAdmin - 2.11.9.3

 

PHP 5.0

osCommerce VERSION;

define('PROJECT_VERSION', 'osCommerce Online Merchant v2.2 RC2a');

 

I am plugging my way along trying to learn mysql with Google on my left and -phpmyadmin on my right. Installing InfoBox_Admin v2.25

# Adds the function to select 'left' / 'right' from a

# radio box so we don't have to use the keyboard too much...

# Add new function colum

 

ALTER TABLE theme_configuration >>>>>>>>>>>(I have no table called theme_configuration, or at least that i can see)<<<<<<<<<<<<<

ADD set_function varchar(255) NULL DEFAULT 'tep_cfg_select_option(array(\'left\', \'right\'),';

 

# Define the function to all rows

UPDATE theme_configuration SET set_function = 'tep_cfg_select_option(array(\'left\', \'right\'),';

>>>>>>>>>>>#1146 - Table 'apache.theme_configuration' doesn't exist <<<<<<<<<<<<<<<<<

 

I named my store database "apache" (obvious I know)

 

Plus, am i supposed to do something with this line, i have tried to run it without success.

UPDATE SQL 2.24 to 2.25

=============

>>>>>>>>>>>>for use set_function to edit 'left' and 'right' :<<<<<<<<<<<<<<<<<<<<<<<,

(update by Thomas Schittli 31.7.2006)

 

Error

SQL query:

FOR USE set_function TO edit 'left' AND 'right'

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for use set_function to edit 'left' and 'right'' at line 1

 

I know I should learn a lot more about SQL commands, rest assured I am trying.

Any help is appreciated.

what is the full sql query you are trying to execute?

[Guest]

Did you run all the sql files included with the contribution?

[Guest]

The first thing i did was launch phpmyadmin

than i ran

for use set_function to edit 'left' and 'right'

-failed-

 

then i ran

# Adds the function to select 'left' / 'right' from a

# radio box so we don't have to use the keyboard too much...



# Add new function colum

ALTER TABLE theme_configuration

 ADD set_function varchar(255) NULL DEFAULT 'tep_cfg_select_option(array(\'left\', \'right\'),';



# Define the function to all rows

UPDATE theme_configuration SET set_function = 'tep_cfg_select_option(array(\'left\', \'right\'),';

 

-failed with #1146 - Table 'apache.theme_configuration' doesn't exist

 

Sounds quick but it actually took about 6 hours including reading :)