database error

[zeeshankh]

i am getting the following error if i am running my genceportal potal.php.

Database Error
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 '' at line 14
File: /home/zeeshank/public_html/rangbharde/Sources/portal.php
Line: 261

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

[shadow82x]

Go into your database via phpmyadmin

Go to the table SMF_settings
> Change "smfVersion" to: 1.1.4


What is phpMyAdmin?

[zeeshankh]

is there any other way of doing it?

[lordtron]

Yeah you could always reinstall your whole forum. But just chaning the table smfVersion to 1.1.4 would be a lot easier on you.

[shadow82x]

is there any other way of doing it?

Are you confused with what I said. Its pretty simple if you just know how to get into your phpmyadmin from your host.

[zeeshankh]

actually i can't get into phpmyadmin from my host, that's the problem.

[lordtron]

whats your host if you don't mind me asking?

[zeeshankh]

hostgator, and the software they are using is cpanel.

[shadow82x]

hostgator, and the software they are using is cpanel.

There should be a spot for you to access your tables in cpanel. If you cant find it send me a PM and I  can always take a look.

[lordtron]

yeah from cpanel you can access phpMySQL

[zeeshankh]

yes, but i can't access the tables from mysql

[shadow82x]

yes, but i can't access the tables from mysql

You have to theres an option in cpanel. I guess your not looking hard enough.

Look for the part that says "SQL" or "MYSQL"

[zeeshankh]

i clicked on it, and it took me into my sql databases. there the only thing i can do is repair or delete a data base

[shadow82x]

i clicked on it, and it took me into my sql databases. there the only thing i can do is repair or delete a data base

The best thing to do is just search around for it I guess but it would be more logical for someone to go in and take a look for you and can tell you for future reference. Try looking at a few cpanel hosting tutorials it may help. Google is your friend.

http://teamtutorials.com/web-development-tutorials/create-mysql-databse-with-cpanel-and-phpmyadmin

[zeeshankh]

thanx shadow for the link for tutorials, i m now in my phpmyadmin and can access all the tables, now which one should i edit for the site.

[shadow82x]

Go to the table SMF_settings
> Change "smfVersion" to: 1.1.4

[zeeshankh]

i did, and now the error is changed.

now i am getting following error.

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 '' at line 14
File: /home/zeeshank/public_html/rangbharde/Sources/portal.php
Line: 261

[zeeshankh]

does any body know what could've caused it/?

[shadow82x]

This issue is now resolved.

I fixed the error and got your portal working.

@ zeeshankh - For more support start up a new topic if it does not relate to this