["MySQL server has gone away" php admin error, importing large csv file]

got it, had to increace packet siz in mysql.ini

["MySQL server has gone away" php admin error, importing large csv file]

thanks to your advice here i had successfully uploaded a csv file into a mysql database about a week ago in phpmyadmin with no errors, on my wamp server that seems to be working almost perfectly

but the file has just gone from 1000 lines to 3000 lines, and ive tried it again and i got the error

MySQL server has gone away

in phpmyadmin on my attempt to import it

i looked the error up and some guy says it usually means the server has timed out, but i dont believe this because i get the error very quickly on the import

does anyone have another theory about what this error might mean, or a solution?

thanks

[i set some passwords and now i cant get into phpmyadmin]

ah ok thanks bro at least i know

unfortunately i reinstalled WAMP to try to fix this and now i cant visit my own ip address, gives me a 403 evn with my firewall down

what could give me a 403 if my firewall is down?

[i set some passwords and now i cant get into phpmyadmin]

i set some passwords in phpmyadmin and now whenever i click on it to log on it says

Error

 

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

doesnt even give me a chance to type in the password

[specified key was too long, importing an sql file converted from from a mdb file]

idk how to do that

i mean the problems pretty clear isnt it? the primary key in one of the tables must be larger than a k,

so i figured theres something in the microsoft access to limit it,

but more likely theres a better mdb to sql converter out there that can shrink the primary key

thought one of u guys would know of such a program, or how to do it in microsoft access

[specified key was too long, importing an sql file converted from from a mdb file]

i have converted a microsoft .mdb file to an .sql file with a program called bullzip

whenever i try to import  the sql file into a mysql database, weather through phpmyadmin or through the mysql console, it always gives me the error that they key is too long (max length 1000 bytes)

how do i shorten the key or make this problem go away?

thanks guys

[upload_max_filesize 3mb hosts?]

ok well can u tell me a really cheap one? my sister might be willing to pay a little

[upload_max_filesize 3mb hosts?]

im trying to make an art gallery site for my sister with free hosting, i need upload_max_filesize to be at least 3mb

ive tried many free hosting services and they are all 1.5mb

ive tried changing it with .htaccess files and php.ini files, seems the free hosts are cracking down on that stuff

does anyone know of a free hosting service that has at least 3mb upload_max_filesize? or perhaps someone knows of a service where it can be changed with php.ini files or .htaccess files

[upload_max_filesize solutions]

i dont think the folder public_html exists actually

[upload_max_filesize solutions]

im trying to make an art gallery site for my sister with free hosting, i need upload_max_filesize to be at least 3m

ive tried many free hosting services and they are all 1.5m

ive tried what these guys say

http://www.openg.info/entry/php-cpanel-change-upload-max-filesize-cpanel-access-php-ini

 

which is put this in htdocs:

 

.htaccess

#Enables mod_rewrite, otherwise all Rewrite directives below will not work
RewriteEngine on
#Activates php.ini config located in main folder to work also recursively for all subfolders, obviously replace your_cpanel_user with your full path, you find it in cPanel home page on the left it's called 'Home Directory'
suPHP_ConfigPath /home/vol2/20x.cc/20x_6657899/public_html

php.ini

upload_max_filesize = 3M
post_max_size 8M
memory_limit 128M
max_input_time -1

which just gives me a 404

 

and ive tried running this, and it gives me the same old 1.5m every time

index.php

<?php
phpinfo();
ini_set("upload_max_filesize", "3M"); // Think that's right...
phpinfo();
?>

[The exec() function is disabled in your PHP by the disabled_functions parameter]

<?php

phpinfo();

?>

ok but suppose i override these values with an htaccess file or a second php.ini file. which values will be output

[The exec() function is disabled in your PHP by the disabled_functions parameter]

ok well can i at least view the values in php.ini?

[The exec() function is disabled in your PHP by the disabled_functions parameter]

i dont think so its a free hosting site

[The exec() function is disabled in your PHP by the disabled_functions parameter]

how do i enable exec() in php.ini? where is php.ini? cant find it in the directories in my site.

[403 smf ajax chat mod installed on smf forums]

i installed the most popular chat mod on smf forums called ajax chat. i am certain i did everything correctly.

but when i try to test it i get a 403 on byethost. ive also had problems with phpbb

this must mean that byethost must not allow ajax

does anyone know of a server that will allow me to use this mod?

[Strange relative links]

r u kidding me? danm i feel like i should have known that

 

thank you

[Strange relative links]

i have a question about how relative links work

i went to a particular website and saw that i was 2 subdirectories deep, that is i was at www.blabla.com/bla/bla/page

then i looked at the source code of the page and saw that the source of an image was src='/images/soso.png'

so one would expect that the full address of this image was

www.blabla.com/bla/bla/images/soso.png

but it wasn't!!! it was at

www.blabla.com/images/soso.png

this is not how these links usually work.

somehow, the browser knew to use the root directory, instead of the current subdirectory of the page. how did it know?

[->(thank you very much)<- to all who helped me]

A few months ago I knew next to nothing about web development. I then watched like 1000 hours of tutorials and was still a n00b. It was in building the sites and asking questions here and in some other sites that I was able to crack the shell of my egg and spread my wings. I cannot express the depth of my gratitude to those who helped me, but I've at least linked the sites and listed your names in the links section of my resume site. Take a look at what your teachings have produced:

 

http://yankeescreen.000space.com/

http://patrickallard.000space.com/

 

tyvm

[file_get_contents, geshi]

i fixed everything by using file_get_constants without a directory, so i guess ii wont organize the samples into folders. i am certain that the directory was correct though, this will bug me for a long time

[file_get_contents, geshi]

i copied the code right from the websites documentation

[file_get_contents, geshi]

this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Patrick Allard</title>
</head>
<body>
<p>html working</p>
<?
include_once 'geshi.php'; 
$file = file_get_contents('/samples/actionscript/firebutton.as', FILE_USE_INCLUDE_PATH); 
echo $file;
$language = 'actionscript 3';
$geshi = new GeSHi($file, $language);
echo $geshi->parse_code();
?>
</body>
</html>

is producing this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Patrick Allard</title>
</head>

<body>
<p>html working</p>
<pre class="actionscript3" style="font-family:monospace;"> </pre>
</body>
</html>

it should have at least echoed the file back, even if im not doing the geshi class correctly, but i am pretty sure i am. i know the directory of firebutton.as is correct, and im pretty sure i put everything that geshi needs where it should be. i unpacked it so that geshi.php is in the same directory as my script, along with the folders it came with. if you want to check my directorys go here:

http://patiscool.000space.com/pats%20resume%20site%20v1.4/actionscript.php

i have directory listings enabled so u can go up a directory and check.

 

[firefox: cant stop caching]

ty got it lol, ive been reuploading the entire site to deal with this until now lol-

[firefox: cant stop caching]

look at all the stuff i turned off and firefox is still caching:

http://img686.imageshack.us/img686/8079/firefoxstillcaching.png

[html converter besides MS word?]

ty ill give it a try

[html converter besides MS word?]

ive got a resume web site and i want to let my viewers click on a link to a particular code sample of mine to read. ive got .as files, .cpp files, .h files, .js files, ,php files, u name it, but they're all just text. now i tried just linking the user to the unaltered file and that was buggy, and i also tried pasting the code into MS word and saving it as an html file, but that was buggy too, they couldn't get the indents right. is there some software out there that converts text files into readable html with all the indenting done correctly?