med Posted August 28, 2016 Share Posted August 28, 2016 where is category_index tables located ? Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 28, 2016 Share Posted August 28, 2016 This is the name of a table in the database CubeCart uses. To view the contents of thi stable, you will need to use an external utility, such as phpMyAdmin provided as a tool in your hosting control panel. The complete name of this table is CubeCart_category_index. The physical location of the table is (probably) on the computer that is running the MySQL database server. Quote Link to comment Share on other sites More sharing options...
med Posted August 28, 2016 Author Share Posted August 28, 2016 Thanks, actually i want to copy the categories on the store to the second store without repeating the same process of entering the categories again. Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 28, 2016 Share Posted August 28, 2016 You will want to have phpMyAdmin dump the table CubeCart_category to a CSV or SQL file, then take that file and have phpMyAdmin import it into a different database. A CSV file will have just the data and perhaps the top row being the column names, but nothing at all about the table structure. Use this to add more data to an existing, empty table. A SQL file will have instruction that phpMyAdmin will use to completely reconstruct the database table, making sure that category_id values are maintained. The table CubeCart_category_index is used to glue the category(ies) to the product(s). You do not want this table as it references products by product_id that will not be same in the second database. Quote Link to comment Share on other sites More sharing options...
med Posted August 30, 2016 Author Share Posted August 30, 2016 Thanks Bsmither, i did it in another way but, below is the message i got when i want to open the storefront: Please edit this file in the stores root directory with the following content. ##### START CubeCart .htaccess ##### ## File Security <FilesMatch "\.(htaccess)$"> Order Allow,Deny Deny from all </FilesMatch> #### Apache directory listing rules #### DirectoryIndex index.php index.htm index.html IndexIgnore * #### Rewrite rules for SEO functionality #### <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / ######## START v4 SEO URL BACKWARD COMPATIBILITY ######## RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule cat_([0-9]+)(\.[a-z]{3,4})?(.*)$ index.php?_a=category&cat_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule prod_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule info_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=document&doc_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule tell_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule _saleItems(\.[a-z]+)?(\?.*)?$ index.php?_a=saleitems&%1 [NC,L] ######## END v4 SEO URL BACKWARD COMPATIBILITY ######## RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*)\.html?$ index.php?seo_path=$1 [L,QSA] </IfModule> ## Default store 404 page ErrorDocument 404 /index.php ##### END CubeCart .htaccess ##### ##### START CubeCart .htaccess ##### ## File Security <FilesMatch "\.(htaccess)$"> Order Allow,Deny Deny from all </FilesMatch> #### Apache directory listing rules #### DirectoryIndex index.php index.htm index.html IndexIgnore * #### Rewrite rules for SEO functionality #### <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / ######## START v4 SEO URL BACKWARD COMPATIBILITY ######## RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule cat_([0-9]+)(\.[a-z]{3,4})?(.*)$ index.php?_a=category&cat_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule prod_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule info_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=document&doc_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule tell_([0-9]+)(\.[a-z]{3,4})?$ index.php?_a=product&product_id=$1&%1 [NC] RewriteCond %{QUERY_STRING} (.*)$ RewriteCond %{REQUEST_FILENAME} !-f RewriteRule _saleItems(\.[a-z]+)?(\?.*)?$ index.php?_a=saleitems&%1 [NC,L] ######## END v4 SEO URL BACKWARD COMPATIBILITY ######## RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*)\.html?$ index.php?seo_path=$1 [L,QSA] </IfModule> ## Default store 404 page ErrorDocument 404 /index.php ##### END CubeCart .htaccess ##### what would i do for the store to open fine Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 30, 2016 Share Posted August 30, 2016 At this installation, there appears to be a file named .htaccess, but (probably) PHP does not have permission to write the edited version to CubeCart's main folder. I am also concerned that, based on the output you posted above, it shows the current content of that file followed by what CubeCart wants to add. The current content does contain the character sequence (called a string) seo_path, which is what is being tested for, so I do not know why CubeCart is complaining that it is missing. For now, please make sure that PHP has permission to write to the folder where CubeCart is installed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.