When i submit the stup information using mysql database i get the following error.. anyone???
MetaTraffic Setup
STEP 1: Connecting to new database...SUCCESS
STEP 2: Creating database connection file...SUCCESS
STEP 3: Testing configuration file permissions...SUCCESS
STEP 4: Creating new database tables...SUCCESS
STEP 5: Testing database permissions...FAILED
There was a database error:
Number: -2147467259
Source: ADODB.Connection.1
Description: SQLState: S Native Error Code: 1146 [TCX][MyODBC]Table 'tacti9_traffic.mt_Config' doesn't exist
Go back and try again.
setup errors
Hi Ramy,
You are going to need to supply more information such as the database you are using and version, version of MetaTraffic, etc.
~Chad
setup errors
FYI:
The tables createt by setup.asp in MYSQL is not starting with a capital letter that is the error.
setup errors
quote:[i]Originally posted by na[/i]
[br]FYI:
The tables createt by setup.asp in MYSQL is not starting with a capital letter that is the error.
correct tables names in MYSQL is(prefix user here is "mt_"
mt_Config
mt_Definitions
mt_IPCountry
mt_Keywords
mt_Names
mt_PageLog
mt_PageNames
mt_ReferrerNames
mt_Referrers
mt_RobotLog
mt_Sessions
mt_Users
Also I had to change
Dim objTS : Set objTS = objFSO.OpenTextFile(Server.MapPath(strInstallPath) & "\" & strFileName, 1)
to
Dim objTS : Set objTS = objFSO.OpenTextFile(Server.MapPath(strInstallPath) & "/" & strFileName, 1)
diff. is "/"