Tables Database

General Forum
Viggo
Phoca Member
Phoca Member
Posts: 17
Joined: 26 Apr 2008, 12:52
Location: Switzerland
Contact:

Hello, D

Post by Viggo »

Hello,

During the installation the tables were not created in the DB. Following the indications of the User Manual I attempted creating them manually.

I found install.sql in order to copy the text....but this file is empty and contains
nothing.

Did I look into the wrong file ?

Were can I find the text allowing to create manually these tables ?

Many thanks for you help.

Regards

Pieter
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47883
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

you should see the i

Post by Jan »

you should see the install.bak file
If you find Phoca extensions useful, please support the project
Viggo
Phoca Member
Phoca Member
Posts: 17
Joined: 26 Apr 2008, 12:52
Location: Switzerland
Contact:

Hello Th

Post by Viggo »

Hello

Thanks a lot. I have now these two tables in the DB.

But they are shown:

#__phocagallery Afficher Structure Rechercher InsĂŠrer Vider Supprimer 0 MyISAM utf8_general_ci 1,0 Kio -
#__phocagallery_categories

I am unfortunatly not quite familar with the syntax of SQL and did give:


#__phocagallery_categories to jos__phocagallery_categories
#__phocagallery to jos__phocagallery


in order to rename these two tables.

It did not work

Could you please let me know how I have to tell SQL in order to rename them.

Meanwhile I have dropped these two tables and created them on new with:



CREATE TABLE `jos__phocagallery
CREATE TABLE `jos__phocagallery_categories`

in hope this might work,


I wanted to create a category....and got an error message. Category is not created.

Many thanks your help.

Regards


Pieter
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47883
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

not:#__phocaga

Post by Jan »

not:
#__phocagallery_categories to jos__phocagallery_categories
#__phocagallery to jos__phocagallery

but:
#__phocagallery_categories to jos_phocagallery_categories
#__phocagallery to jos_phocagallery

- system installation: #__
- manual installation: e.g. jos_ (only one _ )
If you find Phoca extensions useful, please support the project
Viggo
Phoca Member
Phoca Member
Posts: 17
Joined: 26 Apr 2008, 12:52
Location: Switzerland
Contact:

Jan many thanks for

Post by Viggo »

Jan many thanks for the help.

With this correction it worked.

Regards

Pieter
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47883
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

...

Post by Jan »

If you find Phoca extensions useful, please support the project
Post Reply