 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
|
|
|
|
|
??
