Now Having Trouble With a Contribution!

[angel_duzt]

I have installed the Dynamic Information Pages Dip1.1 contribution and followed the instructions religiously. Now it is obviously installed right as it shows up in my admin. Only problem being is this error when I click on it:

 

1146 - Table 'annsum_osc1.pages' doesn't exist

 

select p.pages_id, pd.pages_name, p.pages_image, p.pages_date_added, p.pages_last_modified, p.pages_status from pages p, pages_description pd where p.pages_id = pd.pages_id and pd.language_id = '1' order by pd.pages_name

 

[TEP STOP]

 

:'(

 

 

Does anyone knw what the problem is and more importantly how I can get it working, as this would be a great thing to have in my admin! I have tried contacting the creator, but he wasnt much help.

 

Thanks in advance

Emma

[Rob123]

It seems you are missing a couple of tables in your database.

I never installed this contribution but I think I know what the problem is.

 

The instructions say

Run the included information.sql on your catalog database. This will add the tables to your database.

There is no information.sql however there is a file called Dip_1.0.sql.

 

If you run Dip_1.0.sql in phpmyadmin or your favorite sql tool, it will create the tables for you in your database.

 

If it works, it would be helpful if you could tell the author.

 

HTH,

Robert

[angel_duzt]

It seems you are missing a couple of tables in your database.

I never installed this contribution but I think I know what the problem is.

 

The instructions say There is no information.sql however there is a file called Dip_1.0.sql.

 

If you run Dip_1.0.sql in phpmyadmin or your favorite sql tool, it will create the tables for you in your database.

 

If it works, it would be helpful if you could tell the author.

 

HTH,

Robert

<{POST_SNAPBACK}>

 

Hi Robert

I am not sure how to run it in phpMyAdmin? I have never even been in there before! Would yo ube able to tell me where i can find this phpMyAdmin?

regards

Emma

[Rob123]

Hi Robert

I am not sure how to run it in phpMyAdmin?  I have never even been in there before!  Would yo ube able to tell me where i can find this phpMyAdmin?

regards

Emma

<{POST_SNAPBACK}>

myphpadmin is one of several tools available to modify mysql databases.

For instance, I like using a program called sqlyog.

 

You should ask your host on how they want you to access your database in order to "create tables" or run sql scripts.

 

HTH,

Robert

[angel_duzt]

myphpadmin is one of several tools available to modify mysql databases.

For instance, I like using a program called sqlyog.

 

You should ask your host on how they want you to access your database in order to "create tables" or run sql scripts.

 

HTH,

Robert

<{POST_SNAPBACK}>

 

Thanks Robert for the info. I have now contacted my Host.

Regards

Emma :thumbsup:

[ozcsys]

Hi Robert

I am not sure how to run it in phpMyAdmin?  I have never even been in there before!  Would yo ube able to tell me where i can find this phpMyAdmin?

regards

Emma

<{POST_SNAPBACK}>

 

You should be able to find a link to phpmyadmin from the page you created your database from, usually down at the bottom. If you have it then click on it, choose your database, click on the sql tab. You will then see a browse button, click on it, browse to the sql file choose it and click on go. Done!!

 

BACKUP YOUR DATABASE IN YOUR OSC ADMIN FIRST!!!!!!

[angel_duzt]

You should be able to find a link to phpmyadmin from the page you created your database from, usually down at the bottom. If you have it then click on it, choose your database, click on the sql tab. You will then see a browse button, click on it, browse to the sql file choose it and click on go. Done!!

 

BACKUP YOUR DATABASE IN YOUR OSC ADMIN FIRST!!!!!!

<{POST_SNAPBACK}>

 

 

OK have managed to upload the file to phpMyAdmin, I looked in the store admin and now it says this:

TEXT_NO_CHILD_INFORMATION_OR_PAGES

How do I correct this?

[ozcsys]

OK have managed to upload the file to phpMyAdmin, I looked in the store admin and now it says this:

TEXT_NO_CHILD_INFORMATION_OR_PAGES

How do I correct this?

<{POST_SNAPBACK}>

 

Almost every time you see text that looks like that you are missing a define. You need to go over the instructions and see what is missing.

 

Have you checked out the support thread for your contribution? It is usually a good place to start. In fact before installing a contribution you should check out the support thread first to see what problems people have had with it or if it even works at all.

[angel_duzt]

Almost every time you see text that looks like that you are missing a define. You need to go over the instructions and see what is missing.

 

Have you checked out the support thread for your contribution? It is usually a good place to start. In fact before installing a contribution you should check out the support thread first to see what problems people have had with it or if it even works at all.

<{POST_SNAPBACK}>

 

I am going to check through the contributions support forum now, thanks!