Show Posts
|
Pages: [1] 2 3 4
|
1
|
FreePgs Related / Support Requests / Dbase table name caps & spaces
|
on: September 23, 2007, 04:38:50 PM
|
Hi all, Anyone here know how to handle using spaces in table names? I'm using forum software which adds forum names as tables. I haven't had a problems yet, but this puts spaces in the table names, which is just odd. How do others handle this? Doc
|
|
|
4
|
FreePgs Related / Support Requests / Re: damn wtf
|
on: July 27, 2007, 02:11:54 AM
|
use freepgs file manager to edit htaccess, because you wont see it otherwise, wont be visible. watch for caps, as fedora linux is cap sensitive. i had some of those forbidden errors, but it was my urls were wrong.
|
|
|
6
|
FreePgs Related / Support Requests / Re: Plesk "LOCALHOST' 5 is cap sensitive
|
on: July 25, 2007, 10:22:09 PM
|
admin, It was a bit more detailed than clicking "mg". To get to the screen to rename tables, I had to click "open new phpmyadmin page" which then brings me to a 2 column page with linked table names on the left, and rename options on the right column. Thanks, Doc
|
|
|
9
|
FreePgs Related / Support Requests / Re: How to change the database password ?
|
on: July 24, 2007, 03:00:52 AM
|
Hello, What I did, was to backup the mysql file using export, and with a slightly different name. Create blank filename of newly named with a new password, then import data to it. Change program configs, dbase name/passwd in your config files, test everything, then delete the old mysql file.
The above way is much more safe. You could also just export using same name, then delete it from server. Then create filename with new password and then import.
MIke
|
|
|
10
|
FreePgs Related / Support Requests / Re: Plesk "LOCALHOST' 5 is cap sensitive
|
on: July 23, 2007, 11:10:53 PM
|
Hi, I spoke with admin, who said that windows servers are not cap sensitive, while linux servers are. Localhost is fedora linux, which explains the problems I'm having. Does anyone know the correct proceedure for this error? WARNING: errors encountered while processing your request... Function: zdbSqlQuery -- SELECT UserID,nDate,Note,ID from zdocNOTE where DocId='zdoc.14' ORDER BY nDate Called by: getUserNote
Parameter: Table 'db_tml_pb.zdocNOTE' doesn't exist
MySQL said: Table 'db_tml_pb.zdocNOTE' doesn't exist
My table names are not capitalized, and so zdocnote exists, while zdocNOTE does not. With normal php programming, is caps okay like it is with javascript? Which way do I go? Do I need to capitalize the table names suffixes, or do I remove caps from the scripts? here's the error live: http://sirpub.freepgs.com/pb/tml/Please and Thanks, Doc
|
|
|
12
|
FreePgs Related / Support Requests / PHP SAVY???? Ampersands not accepted in URLs
|
on: July 22, 2007, 12:38:32 AM
|
Can someone please tell me why this wont work: THE PHP GETS ARE NOT WORKING, COMES UP WITHOUT CONTENT OR PAGE TITLE: http://trymikey.com/includes/static1.php?title=MainPage&content=form_home-content-tm.phpIf you CHANGE the & (valid html) to & (invalid html) it will work. THE PHP GETS ARE WORKING, GETS CONTENT AND PAGE TITLE: The php scripts which are used for the "get" functions for static pages is: <!-- STATIC SET THE PAGE TITLE --> <?php if($_GET['title']){ // CUSTOM GET TO SUPPRESS ERRORS: if Pt is in the URL // $pgtitle = $_GET['title']; // Assign title=$pgtitle // print('<title>'.$pgtitle.': TryMikey.com</title>'); } ?>
</head>
<body>
<!-- YOUR CONTENT FOR THIS PAGE GOES HERE --> <?php if($_GET['content']){ // CUSTOM GET TO SUPPRESS ERRORS: if Pg is in the URL // $pgcontent = $_GET['content']; // Assign content=$pgname // // $pgcontent specifies the include filename print('<div>'); include('/fpgs/fpgshttpd/trymikey/trymikey/includes/'.$pgcontent);// Any File Name Inserted // print('</div>'); } ?>
|
|
|
13
|
FreePgs Related / Support Requests / Plesk "LOCALHOST' 5 is cap sensitive
|
on: July 20, 2007, 06:30:46 PM
|
Hi folks, I am trying to configure the "LOCALHOST" SERVER, and I am seeing that the new mysql5 is cap sensitive. The programmer has all of the scripts with table names like zdocNOTE, when the table is actually named zdocnote. Well, I'm getting cant find errors. Is the typical mysql table names zdocNOTE or zdocnote? Please and thanks, Mike
|
|
|
|