Condition install error

[ecgbyme]

I install a condition called 'customer_testimonials"

I'm a Newbie and it's my first install, It looks like everything went well in the SQL database as the file appeared and it stated the istall was succesful.

I'm sure I install every .php file and and install every addition code into perspective .php files

However there is one that keeps giving me an error.

 

It goes as an addition into 'column_right.php' and this is the file:

 

/*

Add the following line to either column_left.php or column_right.php

*/

 

include(DIR_WS_BOXES . 'customer_testimonials.php');

 

 

Now I assumed the first part between the /* is instructions only, so I installed the next line of code.

In the file I noticed that other files that are similar have } else { before the file and } after the file. I thought perhaps the designer failed to include these code htmls.

If I install as that I get an error:

 

Parse error: parse error, unexpected ')' in /home/ecgnatur/public_html/store/includes/column_right.php on line 36

 

 

If I install the line of cide just as provided without the } else { the error I get is error:

 

1146 - Table 'ecgnatur_osc1.TABLE_CUSTOMER_TESTIMONIALS' doesn't exist

 

select * FROM TABLE_CUSTOMER_TESTIMONIALS WHERE status = 1 ORDER BY rand() LIMIT 1

 

[TEP STOP]

 

 

I will appreciate very much any help with this problem!! :(

[ecgbyme]

Is there anyone out there! Any good programmers that would know the answer in a heart beat! Please I need to resolve this.

Appreciate any help!

[♥Vger]

The error indicates that the table called customer_testimonials does not exist in the database.

 

Please don't double post in different forums, it's against forum rules and wastes people's time.

 

Vger

[ecgbyme]

Ok, I didn't know about the double post, I did not get any response to this post so I was seeing if there is a better area for this kind of problem. This forum is a little confusing as the areas seem to all be the same - with a different name.

 

You are referring to the SQL database? It is there and has various content.

Here is a view of the content.

 

testimonials_title varchar(64) No Change Drop Primary Index Unique Fulltext testimonials_id int(5) No auto_increment Change Drop Primary Index Unique Fulltext testimonials_html_text longtext No Change Drop Primary Index Unique Fulltext testimonials_name varchar(50) No Change Drop Primary Index Unique Fulltext testimonials_url varchar(150) No Change Drop Primary Index Unique Fulltext testimonials_url_title varchar(150) No Change Drop Primary Index Unique Fulltext date_added varchar(50) No Change Drop Primary Index Unique Fulltext status tinyint(1) No 1 Change Drop Primary Index Unique Fulltext

 

Appreciate your help

[♥Vger]

This is what should have been inputted into your database (as you can see you haven't got all of it):

 

CREATE TABLE customer_testimonials (

testimonials_title varchar(64) NOT NULL default '',

testimonials_id int(5) NOT NULL auto_increment,

testimonials_html_text longtext NOT NULL,

testimonials_name varchar(50) NOT NULL default '',

testimonials_url varchar(150) NOT NULL default '',

testimonials_url_title varchar(150) NOT NULL default '',

date_added varchar(50) NOT NULL default '',

status tinyint(1) NOT NULL default '1',

PRIMARY KEY (testimonials_id)

) TYPE=MyISAM;

 

Vger

[ecgbyme]

This is what should have been inputted into your database (as you can see you haven't got all of it):

 

CREATE TABLE customer_testimonials (

testimonials_title varchar(64) NOT NULL default '',

testimonials_id int(5) NOT NULL auto_increment,

testimonials_html_text longtext NOT NULL,

testimonials_name varchar(50) NOT NULL default '',

testimonials_url varchar(150) NOT NULL default '',

testimonials_url_title varchar(150) NOT NULL default '',

date_added varchar(50) NOT NULL default '',

status tinyint(1) NOT NULL default '1',

PRIMARY KEY (testimonials_id)

) TYPE=MyISAM;

 

Vger

 

What I did was use the Import in SQL and imported the 'New Installation' SQL file provided by the creator.

There appeared in the database a new file called 'customer_testimonials.php.

Could there have been an error in the installation? It did state that the install was successful.

I see the content you provided in a window named fields. Is there something else I needed to do?

I don't see PRIMARY KEY after Status in that window. There also is a field to the left called: Run SQL query/queries on database .... There's a arrow where you can move them to that field. Is there some else I was suppose to do. Appreciate your help!!

[ecgbyme]

As well, there is a note in the install that for some reason:

 

1. Run the sql file to create the new database table.

*** For an unknown reason, the 'status' column is being inserted in caps as 'STATUS'.

*** Rename "STATUS' to 'status' in your sql database.

 

I've looked at the status in the field and it is lower case.

Would anyone know exactly where that might be if not referring to in the field.

[♥Vger]

You should have used the SQL tab in phpMyAdmin and then used the Browse function to locate the local sql file on your computer and then clicked the 'Go' button. This would have uploaded the file and run the sql commands. It looks like you've just uploaded it to the database but not run the sql commands.

 

I'd recommend ticking the box next to the customer_testimonials table and selecting to drop it, and then follow my instructions.

 

Vger

[ecgbyme]

You should have used the SQL tab in phpMyAdmin and then used the Browse function to locate the local sql file on your computer and then clicked the 'Go' button. This would have uploaded the file and run the sql commands. It looks like you've just uploaded it to the database but not run the sql commands.

 

I'd recommend ticking the box next to the customer_testimonials table and selecting to drop it, and then follow my instructions.

 

Vger

 

I deleted the table and reinstalled using your method and got the same info as yours. Thanks:

 

Your SQL query has been executed successfully (Query took 0.0310 sec) SQL query:

#

# Table structure for table `customer_testimonials`

#

CREATE TABLE customer_testimonials(

testimonials_title varchar( 64 ) NOT NULL default '',

testimonials_id int( 5 ) NOT NULL AUTO_INCREMENT ,

testimonials_html_text longtext NOT NULL ,

testimonials_name varchar( 50 ) NOT NULL default '',

testimonials_url varchar( 150 ) NOT NULL default '',

testimonials_url_title varchar( 150 ) NOT NULL default '',

date_added varchar( 50 ) NOT NULL default '',

STATUS tinyint( 1 ) NOT NULL default '1',

PRIMARY KEY ( testimonials_id )

) TYPE = MYISAM

 

The Status is in capitols but below in the lower window where it is edible, it is in lower case.

 

Tried the addition code to install in 'column_right.php' and got the same error. Tried it with the } else { code and got the same other error. In Admin the 'Customer_testimonials' tools are there and they work. I put in a testimonial.

Appreciate any suggestions you may have!