Installation help - MySQL problem.

[BattleDuty]

I was installing URL shortner on my domain "xxx/shrt/xx"

The installation guide was something like this

"Run the file database.sql in the MySQL interface (import->choose file)."

I don't know what does that mean. So I created new DB with new User and password.. Then I edited my config.php file.

I can get the home page load but when I enter some url I get this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/xxx/URL/shorturl/index.php on line 26 

2) The button is not working.. The reset button.



It should clear the space for new url, but when I click nothing happens.

3) According to the guide

"Now change the URL in the .htaccess file in the above configured $sitename URL (RewriteRule ^(.*) http://www.yourdomain.com/?%1 [L])."

Should I just change the URL or remove "?%1 [L])" also?


Thank you.

BattleDuty Reviewed by BattleDuty on 28th Mar 2012. Installation help - MySQL problem. I was installing URL shortner on my domain "xxx/shrt/xx" The installation guide was something like this "Run the file database.sql in the MySQL interface (import->choose file)." I don't know what does that mean. So I created new DB with new User and password.. Then I edited my config.php file. I can get the home page load but when I enter some url I get this error Rating: 5

[Gavo]

Goto phpmyadmin and select your database.

Then click Import and select the .sql file and it will import the tables.

[BattleDuty]

When I click phymyadmin

"This feature is not available while logged in with root override. You are logged in with the root, or reseller's password. Please login with this user's account password or go back. "

Looged in with root account. I don't have any other

Thanks.

[Gavo]

Are you using a cpanel resellers account?

You would need to login using the usernameassword used when adding the account for the site that the database belongs to.

[BattleDuty]

I'm using root ID/Password.. I don't have anything else.

Thanks!

[MediaStar]

I'm using root ID/Password.. I don't have anything else.

Thanks!

u cannot use root, go to http://yourdomain.com/cpanel or :2082 meh

[BattleDuty]

Using :2082 only

Still same.

[MediaStar]

your domain ticked as reseller right?

[BattleDuty]

Reseller Privileges Yes.

[MediaStar]

untick it