Na index.php mi pokazuje > CDatabase::SelectDB() error.Na zakupljenom hostingu postavim software za nekretnine php ,koji koristi *SQL fajl kao bazu i SITE.XML u kome postavim parametre servera databaza i dr.
Napravio sam username database tmmdoo_vladixnov i to je u redu ,a napravio sam i nekoliko baza ,ali kada ubacujem tj. importujem SITE.SQL uvijek mi pise #1050 - Table 'site_expenses' already exists ,iako ne postoji.
u read me pise:
-copy all files to your web host
-use phpmyadmin or your mysql interface to run site.sql against your database.
-open site.xml and edit the database section with your database details.
-go to index.php and login with username of admin with a password of test.
-be sure to change the passwords for the admin and regular user.
Takodje napravio sam i htaccess ,to je sigurno u redu.
Ali uvijek kada ubacim site.sql fajl u
ovo je sadrzaj SITE.XML
Code:
<config upload="./upload/" path="../" url="../">
<formspath>./forms/</formspath>
<default_location>index.php</default_location>
<forms>
<adminpath>./forms/admin/</adminpath>
<userpath>./forms/user/</userpath>
<admintemplate>./templates/form.htm</admintemplate>
<sitepath>./forms/</sitepath>
<sitetemplate>./admin/templates/form.htm</sitetemplate>
</forms>
<database type="mysql">
<server>localhost</server>
<login>tmmdoo_vladixnov</login>
<password>*******</password>
<default>tmmdoo_vladix</default>
</database>
<tables>
<table name="properties">site_property</table>
<table name="expenses">site_expenses</table>
<table name="users">site_users</table>
<table name="vars">site_vars</table>
</tables>
<templates path="./templates/">
<admin path="./templates/admin/">
<template name="login">login.htm</template>
<template name="layout">layout.htm</template>
</admin>
</templates>
</config>
<config upload="./upload/" path="../" url="../">
<formspath>./forms/</formspath>
<default_location>index.php</default_location>
<forms>
<adminpath>./forms/admin/</adminpath>
<userpath>./forms/user/</userpath>
<admintemplate>./templates/form.htm</admintemplate>
<sitepath>./forms/</sitepath>
<sitetemplate>./admin/templates/form.htm</sitetemplate>
</forms>
<database type="mysql">
<server>localhost</server>
<login>tmmdoo_vladixnov</login>
<password>*******</password>
<default>tmmdoo_vladix</default>
</database>
<tables>
<table name="properties">site_property</table>
<table name="expenses">site_expenses</table>
<table name="users">site_users</table>
<table name="vars">site_vars</table>
</tables>
<templates path="./templates/">
<admin path="./templates/admin/">
<template name="login">login.htm</template>
<template name="layout">layout.htm</template>
</admin>
</templates>
</config>
Kada pravim bazu sta trebam da uradim? ispod
I na kraju da kažem da je problem što kada idem na index.php te php aplikacije za nekretnine mi piše CDatabase::SelectDB() error iako sam ubacio SITE.SQL ,ali nije mi jasno???pošto nisam do sada imao iskustva sa bazama.
pozdrav
[Ovu poruku je menjao VlaDiXx dana 06.06.2007. u 02:36 GMT+1]
