Soni Web Question one more

Results 1 to 2 of 2
  1. #1
    Apprentice lovaemint is offline
    MemberRank
    Jul 2010 Join Date
    5Posts

    Soni Web Question one more

    install complete !

    but

    main page is error :)

    Fatal error: Uncaught exception 'DibiDriverException' with message 'Table 'au_server_gs.pages' doesn't exist' in C:\xampp\htdocs\dibi\drivers\mysql.php:173 Stack trace: #0 C:\xampp\htdocs\dibi\libs\DibiConnection.php(341): DibiMySqlDriver->query('Select * FROM p...') #1 C:\xampp\htdocs\dibi\libs\DibiConnection.php(255): DibiConnection->nativeQuery('Select * FROM p...') #2 C:\xampp\htdocs\dibi\dibi.php(281): DibiConnection->query(Array) #3 C:\xampp\htdocs\sqlclass.php(57): dibi::query('Select * FROM p...') #4 C:\xampp\htdocs\router.php(72): SQLCLass->mysqlline('Select * FROM p...', 1) #5 C:\xampp\htdocs\router.php(93): Router->IsMexist('home') #6 C:\xampp\htdocs\router.php(56): Router->PageRender('home') #7 C:\xampp\htdocs\router.php(163): Router->Parse() #8 C:\xampp\htdocs\index.php(122): Router->Run() #9 {main} SQL: Select * FROM pages where link = 'home' thrown in C:\xampp\htdocs\dibi\drivers\mysql.php on line 173


    this error is click the home button...


  2. #2
    Apprentice micaymile is offline
    MemberRank
    Sep 2008 Join Date
    23Posts

    Re: Soni Web Question one more

    Code:
    CREATE TABLE `aion_gs`.`pages` (
    `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `name` VARCHAR( 60 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    `content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    `link` VARCHAR( 60 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL 
    );
    
    
    CREATE TABLE `aion_gs`.`newsfeed` (
    `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `name` VARCHAR( 70 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    `content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    `sub_content` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    `date` DATETIME NOT NULL ,
    `status` INT( 11 ) NOT NULL ,
    `author` VARCHAR ( 70 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL 
    );
    
    INSERT INTO `aion_gs`.`newsfeed` VALUES ('1', 'Welcome on SoNiAion Web page', 'It work\s :-D cool', 'Welcome', '2010-01-09 00:24:34', '0', 'NiceSin');
    INSERT INTO `aion_gs`.`pages` VALUES ('1', 'Download', '<table width=\"50%\" align=\"center\" border=\"1\">\r\n       <tr><td>Launcher</td><td><a href=\"/files/launcher.rar\">Download</a></td></tr>\r\n           </table>', 'Download');
    
    ALTER TABLE `aion_gs`.`account_data` ADD COLUMN `email`  varchar(20) NOT NULL;
    u need edit "aion_gs" sql and aion_ls



Advertisement