FreePgs.com Forum
May 28, 2022, 07:17:18 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: LVCS.NET offers low cost domain registration services.
 
  Home Help Search Login Register  
  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 
2  FreePgs Related / Support Requests / Re: Should I move dbase back to mysql5.freepgs.com?????? on: July 28, 2007, 07:11:00 AM

HI,

  Nobody answered this question, and I'm still wondering.  Another question with
this is that when I try to use "Mysql Administrator" software from my pc, the
dbase host is not accepting "localhost", and I don't know what to do.

Please and thanks,
Doc
3  FreePgs Related / Support Requests / Re: Problems with mysql on: July 27, 2007, 09:25:16 PM

  I downloaded a package called "MYSQL Administrator",
to do quick dbase backup/restore and maintenance on
my own computer.  I also made a folder called "Daily_Backups".

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.
5  FreePgs Related / Support Requests / Should I move dbase back to mysql5.freepgs.com?????? on: July 26, 2007, 12:14:16 AM
Should I move dbase from localhost back to mysql5.freepgs.com?Huh??
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
7  FreePgs Related / Support Requests / Re: Plesk "LOCALHOST' 5 is cap sensitive on: July 25, 2007, 04:30:15 AM
PS: It took some time to find that phpmyadmin wizard page,
but things went perfectly, only took about 2 minutes to change
a dozen table names.
Thanks
doc
8  FreePgs Related / Support Requests / Re: Plesk "LOCALHOST' 5 is cap sensitive on: July 24, 2007, 07:29:16 PM
Admin,

  I truly appreciate your feedback.  Support here is "TOPS".
Which is the correct way to do this?  Which way would a
perfectionist do it?

  "Where did it get messed up" is a different story.

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?

Code:
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
11  FreePgs Related / Support Requests / Re: PHP SAVY???? Ampersands not accepted in URLs on: July 23, 2007, 11:01:00 PM
Hi,
  I dont know what the problem was, but dreamweaver's
auto-formatting seems to have fixed the problem, valid html
and all works. 
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.php

If 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:


Code:

<!-- 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
14  FreePgs Related / Support Requests / Re: FreePgs outages are back on: July 09, 2007, 02:15:59 PM

  There are online tools which one can use to
monitor uptime/downtime. http://dotuptime.com/
is a popular one. 

Mikey
15  FreePgs Related / Support Requests / Re: Please fix this Forum Banner: Needs link back to freepgs.com on: May 02, 2007, 05:52:19 PM
PS:
  There is also a mod add-on package/tool called UNIVERSAL HEADER/FOOTERS, which
gives you two include strings in admin, to be able to insert your header/footers. 

   You guys can have my wholives dot com banner with full instructions if you like,
just email and ask.

Doc
Pages: [1] 2 3 4
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!