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

Topics - 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
Should I move dbase from localhost back to mysql5.freepgs.com??????
#3
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>');
}
?>


#4
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
#5
  Would someone please fix this support forum
banner.  It needs a link back to freepgs.com.
Here's how :)

  What I did was change the home button to
read "Forum", and then insert a button called
"Main" right before it.

To do this, go into the file:

forum/themes/default/language/index.english.php,
and change $txt[103] = 'Home" to Read $txt[103] = 'Forum".

To add the new Main Button; go into;
/forum/themes/default/index.template.php

LOOK FOR THIS:



// SHOW THE [HOME] BUTTOM.
echo ($current_action=='home' || $context['browser']['is_ie4']) ? '<td class="maintab_active_' . $first . '">&nbsp;</td>' : '' , '
<td valign="top" class="maintab_' , $current_action == 'home' ? 'active_back' : 'back' , '">
<a href="', $scripturl, '">' , $txt[103] , '</a>
</td>' , $current_action == 'home' ? '<td class="maintab_active_' . $last . '">&nbsp;</td>' : '';




AND ADD THIS CHUNK JUST ABOVE IT:




// HOW ABOUT THE [MAIN] BUTTON?
echo ($current_action == 'main' || $context['browser']['is_ie4']) ? '<td class="maintab_active_' . $first . '">&nbsp;</td>' : '' , '
<td valign="top" class="maintab_' , $current_action == 'main' ? 'active_back' : 'back' , '">
<a href="../index.php">Main</a>
</td>' , $current_action == 'main' ? '<td class="maintab_active_' . $last . '">&nbsp;</td>' : '';








#6

Hi,
  How do I Backup and then restore, preserving the file permissions?
I moved a php program from one site to another, but I lost the file
permissions!  HELP?
Doc
#7
Support Requests / MYSQL IMPORT PROBLEM
February 17, 2007, 09:59:11 PM
Hi,

  I've been fighting a dbase file for months,
trying to get the file to import.  I contacted
admin, and they tell me to break the dbase
into several sections, so that I can locate the
problem table.

  Well, admin/Ben is correct, in that I was able
to single out the problem table, called template
which is the table which contains all of my CMS
php/html includes. 

  The table is 1.3mb in size, and my question is, would
this size cause a time-out error on freepgs settings? 
I've done several things, otherwise, trying to correct
a possible error,  but I need to know if it's timing-out,
no error, before I keep wasting my time with this monster.

east
#8
Support Requests / Need mysql help!
February 13, 2007, 09:12:58 PM
Hi,
   I've exported my file.sql dbase file from
elsewhere, and am trying to import the text here,
but it's not importing.  It appears to be loading,
but the finished product comes up empty, no tables. 
It's too big to paste, like 2.5mb, and so I need
another option.

  The server is painfully slow... 

  I googled this subject, and came up with
several scenerios, and I'm wondering if someone
can explain to me how to configure this sql command line?

yourbox> mysql -h host -u user -pPasswd yourdatabase < sqlfile.sql

  The problem may be language related, but I have imported this same
file before with no problems.

DE

#9
Support Requests / MYSQL QUESTION
February 13, 2007, 12:52:26 AM
HI,
  Can someone please tell me how to export or convert the database sql into
txt format? I need to find/replace thousands of changed file paths in my
database file.  Previously, I've always been able to export as txt and then
use find/replace-all with dreamweaver or notepad. 
Thanks,
east
#10

My main domain name is doctoreast.com, and inside of that I have wholives.com in a subfolder.
/ works as root for images, but server wont parse php includes with / as root: 

Warning: main() [function.main]: open_basedir restriction in effect. File(/includes/ez2_html-head-meta.html) is not within the allowed path(s): (/tmp/:/fpgs/fpgshttpd/doctoreast/:/fpgs/fpgslogs/68564/:/usr/share/pear/) in /fpgs/fpgshttpd/doctoreast/wholives/index.php on line 11

Warning: main(/includes/ez2_html-head-meta.html) [function.main]: failed to open stream: Operation not permitted in /fpgs/fpgshttpd/doctoreast/wholives/index.php on line 11


  I'm using absolute url instead, unless someone knows of an easy fix.

EAst
#11
Hi,
  I'm using php, wrestling with relative paths, and I'm
wondering if there is anything I can do with rewrite
or something, that I can obtain relative / to mean root.
Relative to current, the ../ and ../../ is not working
due to the php includes being called from different files
in different folders.  I'm certain that some here will know
what I'm speaking of.  Right now, I'm using absolute urls,
as it's the only thing that seems to work. 
Thanks in Advance,
East 
#12
  Newbie here, a bit confused by your instructions on how to
use multiple domain names with subdirectories using .htaccess
The original thread is HERE.

  Why did member "x" called these instructions cheap and amateurish?

  These instructions tell me that I must ask you to add *.mydomain.com to
my account, but I got an error, unacceptable characters, using the *,
when adding it using the Setup Domains page.

   Using two domain names, can someone please clarify how to modify
these scripts, if the two domain names are actually called:
domain1.com and domain2.com

If you need to apply this change to only ONE domain,
put this code in /.htaccess (root):


RewriteEngine On
RewriteCond %{HTTP_HOST} ^(www\.)?EXAMPLE.NET$
RewriteRule ^(DIRECTORY\/)?(.*)$ DIRECTORY/$2 [L]



Then, in DIRECTORY/.htaccess (subdomain folder), write
the following code:


RewriteEngine On
RewriteCond %{HTTP_HOST} !^(www\.)?EXAMPLE.NET$
RewriteRule ^(DIRECTORY/)?(.*)$ http://www.EXAMPLE.NET/$2 [L,R=301]



Thanks in Advance,
East