trouble with script (sql error?)

14 replies
So I found a script that I'd like to use for a website but cant seem to figure out how to set it up.. I read the instructions and filled out the config as best as i could, but my site always comes up "500 internal server error"

here's what i need to fill out:


$config['basedir'] = '/home/username/public_html';
$config['baseurl'] = 'http: //w w w*website*com';
$DBTYPE = 'mysql';
$DBHOST = 'localhost';
$DBUSER = 'database_username';
$DBPASSWORD = 'database_password';
$DBNAME = 'database_name';

(bold = positive its correct).
So here's what I have.. the website i'm scripting is actually a subdirectory, its called hatewhatever* com.. Hatewhatever* com is intalled (and points to) /hw because my other site is installed into the root. I have "basedir" as /hw and "baseurl" as hatewhatever* com , as for local host, i just clicked on my sql info and copied/pasted the info which is basically myhostingusername*myhostSQL* com, it does not display or ask for port numbers, but i've tried 3306 and it still didnt work. also i've tried dearidiot* com as baseurl, also dearidiot* com/hw and basically every variation of it.


does anyone have ideas?

its particularly frustrating because i've never attempted something like this, and i spent $50 for the script.. I'm up to the challenge and want to learn these things but I have no one to ask except you guys

any help is appreciated


(cant post links yet so i had to edit with *s and spaces)
#error #script #sql #trouble
  • Profile picture of the author KirkMcD
    A 500 error could be anything. Instead of guessing, have you checked the site's error logs in cPanel as to the problem?
    {{ DiscussionBoard.errors[2615174].message }}
  • Profile picture of the author Aperio
    My guess will end up being that it is actually a problem stemming from an .htaccess file that has directives in there that your server doesn't like. If you have an .htaccess file, try renaming it or removing it (of course, make sure you have a backup copy downloaded to your computer first) and while the site may not function properly, just see if it is now able to load and go from there.

    Just my quick .02
    Signature
    Niche Website Packages- Great deals on complete niche website packages. Use coupon code WFDEALS and get an additional discount.
    {{ DiscussionBoard.errors[2615261].message }}
  • Profile picture of the author paulisa2
    Hi there,
    I setup scripts like this for people everyday. I would need details of who your webhost is and the script name I can then step you through the whole process.
    {{ DiscussionBoard.errors[2621801].message }}
  • Profile picture of the author ExpertsGuide
    Try giving your sub dir in this
    $config['baseurl'] = 'http: //w w w*website*com/subdir';
    {{ DiscussionBoard.errors[2622049].message }}
  • Profile picture of the author gfsocial
    Like kirk said.. 500 errors can be many things... .htaccess is common.. but also ive seen 500 errors from using a php4 script and incorrect and poor outdated coding...

    without having a look at the site.. or knowing the script... cant help you much more than what has been said in here...
    {{ DiscussionBoard.errors[2625730].message }}
  • Profile picture of the author roydsilva2
    If you are facing trouble with SQL script, then it is probably due to error in stemming from the .htaccess files or improper server operations.
    {{ DiscussionBoard.errors[2670584].message }}
  • Profile picture of the author SmartWeb
    Originally Posted by dearidiot View Post

    So I found a script that I'd like to use for a website but cant seem to figure out how to set it up.. I read the instructions and filled out the config as best as i could, but my site always comes up "500 internal server error"
    One thing i can assure you that problem is not related with the SQL settings you are doing. if you have any problem in these basic SQL , you would get very good text saying 'can not connect to sql' or any other mentioning the error.

    "500 internal server error" is very common if there are some php coding errors. or if your site is not configured properly for the script you trying to run.

    like all said, its very hard to tell the actual reason why its happening, some expert need to look into the problem with detail.
    if you don't find any person to help, let me know. i would help you if you want.
    {{ DiscussionBoard.errors[2670893].message }}
  • Profile picture of the author cyphix
    Yep...... 500 errors almost always are problems with something in the .htaccess file.
    {{ DiscussionBoard.errors[2671057].message }}
  • Profile picture of the author jakeseth12
    There can be several reasons for 500 errors like .htaccess, php4 script and problem in coding or use of outdates coding in scripts etc.
    {{ DiscussionBoard.errors[2673694].message }}
  • Profile picture of the author robertransey
    If you are covering trouble with SQL script, then it is likely due to mistake in stanching from the .htaccess files or wrong computer activities.
    {{ DiscussionBoard.errors[2760590].message }}
  • Profile picture of the author zeeshi570
    turn on shorttags and mod_rewrite on your server
    {{ DiscussionBoard.errors[2767845].message }}
  • Profile picture of the author meganmatthew
    "500 Internal Server Error" is very general, there are some php coding errors. Or if your site is not configured correctly then this type of errors will show. Also it depends on your database coding.
    {{ DiscussionBoard.errors[2775623].message }}
  • Profile picture of the author adroypaul
    Banned
    If you are confronting difficulty with SQL script, then it is believably due to mistake in stanching from the .htaccess files or unlawful server mental process.
    {{ DiscussionBoard.errors[2872165].message }}
    • Profile picture of the author espradley
      You can turn of error display of php scripts. When you do this, if an error is encountered it serves the 500 error page.

      Although a number of things can cause this, its usually a permissions issue or a .htaccess issue.

      Who do you host with?
      Signature

      Eddie Spradley

      {{ DiscussionBoard.errors[2873233].message }}

Trending Topics