News:

Click here for Toll-Free Service for your business starting at $2.00 per month

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - doctoreast

#1
Support Requests / Dbase table name caps & spaces
September 23, 2007, 08: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

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
Support Requests / Re: Problems with mysql
July 28, 2007, 01:25:16 AM

  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
Support Requests / Re: damn wtf
July 27, 2007, 06: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
Should I move dbase from localhost back to mysql5.freepgs.com??????
#6
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
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
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
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
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
#11
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
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:




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

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

Mikey
#15
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