humm : I just saw that this is version 2.2 was released yesterday and my sql dump is for 2.0 so refer to readme how to upgrade from 2.0 and 2.1 to 2.2 ... You just need to do this in phpmyadmin : ALTER TABLE dir_pend_cat ADD meta_title CHAR(100) NOT NULL DEFAULT '' AFTER name; ALTER TABLE dir_pend_cat ADD meta_description CHAR(255) NOT NULL DEFAULT '' AFTER meta_title; ALTER TABLE dir_pend_cat ADD meta_keywords CHAR(255) NOT NULL DEFAULT '' AFTER meta_description; ALTER TABLE dir_cat ADD meta_title CHAR(100) NOT NULL DEFAULT '' AFTER name; ALTER TABLE dir_cat CHANGE description meta_description CHAR(255) NOT NULL DEFAULT '' AFTER meta_title; ALTER TABLE dir_cat ADD meta_keywords CHAR(255) NOT NULL DEFAULT '' AFTER meta_description; ALTER TABLE dir_settings ADD cat_list INT(11) NOT NULL DEFAULT '0' AFTER pay_options; ALTER TABLE dir_settings ADD pend_list INT(11) NOT NULL DEFAULT '0' AFTER cat_list; Code (markup):
i am trying to do as you said iatbm .. infact figuring how to do it.. i am newbie at it. in the myphpadmin if u could help me how to do it.. ..il be glad
i have done with everything, now which categories database do i need to use? the one on your website? 20kb one? or the one u posted on this page?
The one on page 20kb one ... make sure you empty your current database !! then install mine and do those alter tables in readme.txt file of the script
oops just ran the 20kb one lol and now running the code from the readme file and messed up again, as it says the duplicate entries lemme wait for the new sql dump now
i am dead.. now// i am newbie at it.. now how do i again revery back the improper changes i did in the database... coz i am waiting for the new of iatbm helpme!
Ok I uploaded new sql dump .... You can download it at the same place ! Now .... erase everything you have and install the script again Then : 1. go to phpmyadmin and drop dir_cat table 2. import sql dump file or click SQL in phpmyadmin and copy/paste into the field and click go 3. you are done
Strange i am getting a error while adding the file SQL query: -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 04, 2006 at 12:18 PM -- - -- -- -------------------------------------------------------- -- -- Table structure for table `dir_cat` -- CREATE TABLE `dir_cat` ( `cat_id` int( 11 ) NOT NULL default '0', `parent_id` int( 11 ) NOT NULL default '0', `name` varchar( 50 ) NOT NULL default '', `meta_title` varchar( 100 ) NOT NULL default '', `meta_description` varchar( 255 ) NOT NULL default '', `meta_keywords` varchar( 255 ) NOT NULL default '', `indexdisplay` char( 1 ) NOT NULL default '', KEY `name` ( `name` ) , KEY `cat_id` ( `cat_id` ) , KEY `parent_id` ( `parent_id` ) ) TYPE = MYISAM 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 '- -- -- ----------------------------------------------------- PHP:
humm : make sure you leave ( in line 26 and delete TYPE=MyISAM; ampitel : change line 53 in show_cat.php to this : $row = @mysql_fetch_array($rst); I don't know exactly it should work ... It is working fine on my server when I do clean install with sql dump
Better i will install on a new domain name on a differant host. this one i will use any other script for now Thanks for your help and assistance. I will surely contact you when i get the other name
i didn't need to delete anything, u just made a small mistake i take.. or maybe i while copy/paste -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 04, 2006 at 12:18 PM -- - -- -- -------------------------------------------------------- -- -- Table structure for table `dir_cat` -- CREATE TABLE `dir_cat` ( `cat_id` int(11) NOT NULL default '0', `parent_id` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `meta_title` varchar(100) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `meta_keywords` varchar(255) NOT NULL default '', `indexdisplay` char(1) NOT NULL default '', KEY `name` (`name`), KEY `cat_id` (`cat_id`), KEY `parent_id` (`parent_id`) ) TYPE=MyISAM; PHP: see there is only only - correct code is -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 04, 2006 at 12:18 PM -- -- corrected by adding one more - -- -- -------------------------------------------------------- -- -- Table structure for table `dir_cat` -- CREATE TABLE `dir_cat` ( `cat_id` int(11) NOT NULL default '0', `parent_id` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `meta_title` varchar(100) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `meta_keywords` varchar(255) NOT NULL default '', `indexdisplay` char(1) NOT NULL default '', KEY `name` (`name`), KEY `cat_id` (`cat_id`), KEY `parent_id` (`parent_id`) ) TYPE=MyISAM; PHP: works perfect now.. no error at all http://www.technofreakonline.com/index.php
Hi Guys My problem is different Message at install.php Notice: Undefined index: act in E:\myclients\sonkali_bcoder\dir\is\install\install.php on line 41 I contnue installing : Notice: Undefined index: status in E:\myclients\sonkali_bcoder\dir\is\login.php on line 68 Notice: Undefined index: status in E:\myclients\sonkali_bcoder\dir\is\login.php on line 73 What is problem Thanks in advance