NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page Database help

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search
5 members in live chat ~  


Reply
 
LinkBack Thread Tools
Old 03-28-2010, 09:16 AM THREAD STARTER               #1 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Database help


Problems solved!
Last edited by tech4; 03-28-2010 at 03:39 PM.
tech4 is offline   Reply With Quote
Old 03-28-2010, 09:37 AM   #2 (permalink)
NamePros Regular
 
pixelhero's Avatar
Join Date: May 2008
Location: England
Posts: 771
pixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to all
 


Help The Homeless - Holiday 2009
Often means you're connecting with the wrong username+password. check they are 100% correct for the database you are connecting to.
pixelhero is offline   Reply With Quote
Old 03-28-2010, 10:07 AM THREAD STARTER               #3 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Well how do I change it? is it the config file or the .htaccess file?
Last edited by tech4; 03-28-2010 at 10:11 AM.
tech4 is offline   Reply With Quote
Old 03-28-2010, 10:22 AM   #4 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
Originally Posted by tech4 View Post
Well how do I change it? is it the config file or the .htaccess file?
config file usually...is it a directory?
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 10:38 AM THREAD STARTER               #5 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Yes its a directory. I think.
I don't know why I also have many .htaccess in there.

....
Let me try to make the changes to the config. if it will work.

The config file is in connections and connections_server. Are those the right folders?
I have like 10 .htaccessfiles around too...don't know why they are all there.
How would I open the .htaccess ? and would site work if I delete them all?
tech4 is offline   Reply With Quote
Old 03-28-2010, 10:48 AM   #6 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
Originally Posted by tech4 View Post
Yes its a directory. I think.
I don't know why I also have many .htaccess in there.

....
????: NamePros.com http://www.namepros.com/programming/647396-database-help.html
Let me try to make the changes to the config. if it will work.

The config file is in connections and connections_server. Are those the right folders?
I have like 10 .htaccessfiles around too...don't know why they are all there.
How would I open the .htaccess ? and would site work if I delete them all?
Yikes...sounds like you've got a mess in there - you should only have one .htaccess
as far as I know.

If I were you, I'd be trying to deal with that first...are they all in one file?
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 10:55 AM   #7 (permalink)
NamePros Regular
 
pixelhero's Avatar
Join Date: May 2008
Location: England
Posts: 771
pixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to allpixelhero is a name known to all
 


Help The Homeless - Holiday 2009
what is on line 40 of paging_class.php?

How are you connecting to the database?
pixelhero is offline   Reply With Quote
Old 03-28-2010, 11:05 AM   #8 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
For the config file,
public_html > include > config.php

for the mysql stuff - should look something like this?

define('LANGUAGE', 'en');
define('DB_DRIVER', 'mysql');
define('DB_HOST', 'localhost');
define('DB_NAME', 'dbname_dbname');
define('DB_USER', 'dbname_username');
define('DB_PASSWORD', 'password');
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 11:15 AM THREAD STARTER               #9 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Thanks for the responses. Yes I have like 10 .htaccess files. But they are in different folders (don't know why) and some of them are a bit different. But since I haven't touch them, I am not going to.
????: NamePros.com http://www.namepros.com/showthread.php?t=647396

Thanks for the advice everyone.

Yes the config files are fixed and updated with new password and usernames.

The problem was the new host, changed the database name, changed the user name, changed the password and I have a few directories for a few config files. Basically the config files were the same thing, just like Mod Mis_chiff mentioned. I went in there, and changed everyone of them.

So problem solve.
But I have another one, before I went to the new host, my old host (or programmer) deleted my old database, so I did not make a backup of the few updated files, but still have them I believe. So I am going back to the old host(still have an account) and trying to download a few files to test which ones are updated.

Thanks everyone!
tech4 is offline   Reply With Quote
Old 03-28-2010, 11:18 AM   #10 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
Originally Posted by tech4 View Post
Thanks for the responses. Yes I have like 10 .htaccess files. But they are in different folders (don't know why) and some of them are a bit different. But since I haven't touch them, I am not going to.

Thanks for the advice everyone.

Yes the config files are fixed and updated with new password and usernames.

The problem was the new host, changed the database name, changed the user name, changed the password and I have a few directories for a few config files. Basically the config files were the same thing, just like Mod Mis_chiff mentioned. I went in there, and changed everyone of them.
????: NamePros.com http://www.namepros.com/showthread.php?t=647396

So problem solve.
But I have another one, before I went to the new host, my old host (or programmer) deleted my old database, so I did not make a backup of the few updated files, but still have them I believe. So I am going back to the old host(still have an account) and trying to download a few files to test which ones are updated.

Thanks everyone!
Glad you got it resolved....
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 11:18 AM THREAD STARTER               #11 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Problems solved!
Last edited by tech4; 03-28-2010 at 03:40 PM.
tech4 is offline   Reply With Quote
Old 03-28-2010, 11:25 AM   #12 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
Looks like it's not finding something relating to the template..

what version directory type are you installing?
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 11:39 AM THREAD STARTER               #13 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Problems solved!
Last edited by tech4; 03-28-2010 at 03:40 PM.
tech4 is offline   Reply With Quote
Old 03-28-2010, 11:47 AM   #14 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
I'll just say fingers crossed this time
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 06:07 PM THREAD STARTER               #15 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



You're so right!
????: NamePros.com http://www.namepros.com/showthread.php?t=647396

I got another one!
Warning: mkdir() [function.mkdir]: Permission denied in /usr/home/allfoodm/domains....file.php in line 18

What does a warning mean?
Why is permission to write denied?

Does it have to do with that file.php in line 18?

This is what line 18 is
How can I fix it?

$dir = realpath("../uploadedfiles");

if (is_dir($dir)) {



srand(make_seed());

$id = md5(time().rand());

$dir .= DIRECTORY_SEPARATOR.$id.DIRECTORY_SEPARATOR;
// $dir .= DIRECTORY_SEPARATOR.$id;

Line 18 here>>>>if (!is_dir($dir) && mkdir($dir)) chmod($dir,0777);



if (is_dir($dir)) {

$filename = $dir.basename($filename);

if ($filename && ((file_exists($filename) && unlink($filename)) || !file_exists($filename))) {

move_uploaded_file($_FILES['filename'.$i]['tmp_name'],($filename)) ;

$uploaded = true;
tech4 is offline   Reply With Quote
Old 03-28-2010, 07:03 PM   #16 (permalink)
goof free!
Join Date: Mar 2006
Location: Canada
Posts: 9,364
mis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatnessmis_chiff Has achieved greatness
 


Member of the Month
November 2007
Save a Life VA Tech Memorial Breast Cancer Protect Our Planet Protect Our Planet
Looks like folder or file permissions, I don't know how to decipher
the code to know what's wrong - if anything in that -
but permissions is what I would try if I got that error.
mis_chiff is offline   Reply With Quote
Old 03-28-2010, 07:11 PM THREAD STARTER               #17 (permalink)
Senior Member
Join Date: Jun 2008
Posts: 1,029
tech4 is just really nicetech4 is just really nicetech4 is just really nicetech4 is just really nice
 



Thanks (I got the answer from Digitalpoint)
Problem solved! AGAIN!

It was the permission thing. The line said permission set to 0777
while the file permission was set to like 775 or something, so I had to rewrite it to 777.

Thanks Mis_chiff
tech4 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


 
All times are GMT -7. The time now is 02:36 PM.

Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger