Jul 24, 2008

Bug In Php & Mysql - bug in Php & Mysql
Free Web Hosting, No Ads > CONTRIBUTE > Computers > Programming Languages > PHP Programming

free web hosting

Bug In Php & Mysql - bug in Php & Mysql

moger
May 19 2006, 01:29 PM
hello.. my name moger.. laugh.gif
i new in here..

how if we learning about bug in php n mysql in here forum..??
i'm not found about bug php & mysql in this forum.!! ------>> may i dont know how to use search fasility in this forum tongue.gif

if u wont.. we can start on bug php & mysql maybe..

regards

if u have a problem in your mysql database u can search about mysql bug on this url
http://bugs.mysql.com/search.php

regards

Since I'm using PHP 4.2.3 phpMyAdmin (http://www.phpmyadmin.net) does
not work properly anymore. To me it seems as if string routines would be
broken. As an example I have two errormessages generated from
phpMyAdmin:

Creating a simple table with ID as auto_increment:

--
CREATE TABLE `atest` (

`ID` INT NULL _INCREMENT,
PRIMARY KEY ( `ID` )
)

MySQL meldet:

You have an error in your SQL syntax near '_INCREMENT, PRIMARY KEY
(`ID`))' at line 1
--

It seems as if this PHP version would kill the "auto" in front of
"_increment". Of course, then MySQL produces an error.

Second example: If I change a value (DATE), I get the following error:

--
UPDATE `termine` SET `datum` = '-09-23' WHERE `ID` = \'42\' LIMIT 1;

MySQL meldet:

You have an error in your SQL syntax near '\'42\' LIMIT 1' at line 1
--

There is one ' too much (changing MagicQuotes did not help anything)

I do not thing that this is a problem of phpMyAdmin because I just
recompiled PHP 4.2.2 with exactly the same configure options on the same
system (2 days difference, so no new libraries etc) and everything works
just perfect.

My confiugure Line:
--
'./configure' '--prefix=/usr/share' '--datadir=/usr/share/php'
'--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include'
'--with-config-file-path=/etc/httpd' '--with-exec-dir=/usr/lib/php/bin'
'--disable-debug' '--enable-bcmath' '--enable-calendar' '--enable-ctype'
'--enable-dbase' '--enable-discard-path' '--enable-exif'
'--enable-filepro' '--enable-force-cgi-redirect' '--enable-ftp'
'--enable-gd-imgstrttf' '--enable-gd-native-ttf'
'--enable-inline-optimization' '--enable-magic-quotes'
'--enable-mbstr-enc-trans' '--enable-mbstring' '--enable-memory-limit'
'--enable-shmop' '--enable-sigchild' '--enable-sysvsem'
'--enable-sysvshm' '--enable-track-vars' '--enable-versioning'
'--enable-wddx' '--enable-yp' '--with-bz2' '--with-ftp' '--with-gdbm'
'--with-gettext' '--with-gmp' '--with-imap=yes'
'--with-jpeg-dir=/usr/lib' '--with-ldap=yes' '--with-mcal=/usr'
'--with-mcrypt' '--with-mysql=/usr' '--with-ndbm' '--with-pgsql=/usr'
'--with-snmp' '--with-t1lib' '--with-ttf' '--with-freetype-dir=yes'
'--with-zlib=yes' '--with-openssl' '--with-curl' '--with-imap-ssl'
'--with-gd=yes' '--with-mm' '--with-apxs=/usr/sbin/apxs' '--with-ming'
'--with-mhash' '--with-pdflib' '--with-png-dir=/usr/lib'
'--with-tiffs-dir=/usr/lib' '--with-iodbc'
--
I do not include a backtrace because PHP does not crash at all. The
system continues to run, the page gets finished and I can continue to
work with PHP.

Notice from jlhaslip:
Merged posts. deleted duplicate.
please read the trap17 readme file to learn about posting policy.
Moving to php topic.

 

 

 


Reply

beeseven
May 20 2006, 12:22 AM
What are you trying to say?!

Reply

NeOniX
Jul 21 2006, 03:50 PM
Ehm sorry but i haven't understood what are u trying2say, what means:
QUOTE(moger @ May 19 2006, 03:29 PM) *


how if we learning about bug in php n mysql in here forum..??
i'm not found about bug php & mysql in this forum.!! ------>> may i dont know how to use search fasility in this forum tongue.gif

if u wont.. we can start on bug php & mysql maybe..

???
ph34r.gif

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : bug, php, and, mysql, bug, php, and, mysql

  1. Create Table - Mysql Code - Help
    (1)
  2. Mysql Error
    (3)
    ok i need some more help from the wonderful coders here at Trap. I'm almost done with my CMS
    script, but i'm having a problem with the installer.php file, when it trys to inseret the user
    data into the database i keep getting the following error: CODE mySQL Error: You have an
    error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
    right syntax to use near ';INSERT INTO `members` (`id`, `name`,
    `username`, `password`, `email`, `title`) ' at lin....
  3. Html Form!
    Using MySQL?! (4)
    Hey, I need your help again! I need some good working tutorial how I can update my SQL through
    HTML form. I did use some tutorials online found with the help of google; but they do not work
    properly; I mean there are still small mistakes. I need to have a good tutorial to follow. It
    should be based on security and more things. It has to be done in proper way.......
  4. Best Php And Mysql Editor For Noobs
    anyone any php or mysql editor that is good for noob (6)
    hi there guys, from my previous posting, i am a noob in php and mysql programming. I want to know
    if there are any php and mysql editors which are best for me as a noob. i appreciate your kindness
    ....
  5. Php And Mysql Programming
    anyone knows a code for mysql and php (2)
    hi everyone! I am making a program using php and mysql...I am a noob on this so i need your
    help guys...I want to make a simple program that will some values and then store them on a database
    and then retrieve them...uhmm let me give an example out put of what i need. This is the example
    say..: Enter First Name: Enter Last Name:
    Enter Age: Enter Address: ..those
    are the data needed for input values...my question now is how can I make a database....
  6. Best Sites For Learning Php-mysql
    (4)
    Hi I was reminded of this earlier by a post in a topic, meant to post it but forgot and the topic on
    php books reminded me. Well anyway there is tyhschools for learning php (unless someone else knows
    a better 1) but I wan't to know what is the best site for using php with mysql (using
    phpmyadmin) also whats the difference between postgresql and mysql? though I must admit the
    postgresql version of phpmyadmin whatever it's called looks better (visually)!....
  7. Tools Needed!
    PHP & MySQL (9)
    Hello, everyone! I need some tools for those two things to test PHP scripts coming together with
    database on my laptop, instead checking them on a web-server which takes time.....
  8. Php + Mysql Question!
    While inserting data into MySQL, how can I know if the data I'm in (4)
    Basically, I want to know if the Data I'm inserting through a Form is already there or not. Sort
    of a Username registration page. I have this, but it doesn't appear to work... CODE
    $result = mysql_query("SELECT * FROM users WHERE
    username='$username'"); if($result == 1)     {     echo
    '<h1>ERROR!</h1>The username you have chosen already exists!';     }
    ....
  9. Mysql Won't Update
    (4)
    Ok, so I'm making some arcade administration software so I don't have to add games the hard
    way, well anyway, one of the features I have is that on the homepage is a featured author and as
    such I just have it so it updates one line in the mySQL. Well, the page with the form passes on the
    varibles fine and the updating page recieves them because I echoed everything, then I build the
    query and I even echo the query and it comes out exactly how I want it to, but for some reason, the
    database itself won't update even though all the varibles are there. Here's....
  10. [php/mysql]id Trouble [resolved]
    (3)
    session_start(); include "database.php"; if (!$_SESSION || $_SESSION { // User
    not logged in, redirect to login page Header("Location: main.php"); } $result =
    mysql_query("select * from users order by id asc"); while($r=mysql_fetch_array($result))
    { $username=$r ; $info=$r ; $msn=$r ; $email=$r ;
    $id=$r ; $password=$r ; $userlevel=$r ; echo "
    user ID User Level U....
  11. [mysql/php]need Som Basic Help
    (13)
    QUOTE session_start(); include "database.php"; include "edit.inc.php"; if (!$_SESSION
    ) { // User not logged in, redirect to login page Header("Location: main.php"); }
    if(isset($_POST )){ $email = $_POST ; $msn = $_POST ; $info =
    $_POST ; $updateemail = "UPDATE users SET email = '$email', msn =
    '$msn', info = '$info' WHERE username = '$username'";
    mysql_query($updateemail) or die("culd not edit your info"); echo "info updated"; } //
    Display log....
  12. [mysql]get Id Of Loged In User?
    (7)
    how to get the id number of the loged in user? my db is id. username. password. i have tryed a
    few things.. but i never seem to get it right /ohmy.gif" style="vertical-align:middle" emoid=":o"
    border="0" alt="ohmy.gif" />....
  13. The Artists Tutorials :mysql Basic Commands
    The Artists is an online programming unit and gfx designing clan. (0)
    Let's Talk about basic mysql commands used in php. I will now show you a list of the most common
    MySQL FUNCTIONS : QUOTE mysql_connect(MySQL server name,username,password) - opens a connection
    to a MySQL server. mysql_select_db(database name,connection id) - selects a database residing on
    the MySQL server. The database name parameter referes to an active database on the MySQL server that
    was opened with the mysql_connect function. The connection identifier is a reference to the current
    MySQL connection. mysql_query(sql query) - sends a query to the currently ac....
  14. Problem With A Mysql Join
    Problem with a mysql join (2)
    Hello I am trying to write a script whereby I can pull an image out of one database table and
    display it in relation to its category_id in another table. I am using a my_sql join function that
    is joining the tables correctly, however it only shows the one same image from the top field of
    those combined rows on every single page. I need it display the image according to its category_id
    for that particular page. I am thinking I need to set variables to represent those specific rows but
    I'm not sure how to do that. Here is my code CODE { $result = mysql_que....
  15. Getting Php 5 To Work With Mysql
    getting PHP 5 to work with MySQL (0)
    Just thought this would be of extreme help to those who are planning to migrate to php5 and still
    continue using MySQL same way as before:.... to get mysql work with the php 5 copy
    /dll/libmySQL.dll to the directory where php 5 resides and copy the /extensions/php_mysql.dll to the
    directory where php.exe resides.(if you can't find the two above files probably you are using an
    old release of php 5.you should check for latest at :http://snaps.php.net/) in additon uncomment
    extension line in php.ini and add the following code to a gnereal database file(dbcon.php) in m....
  16. Php And Mysql Applications
    (3)
    Ok I have started useing PHP and MySQL recently and I am wondering how I go about createing an
    application. I looked for tutorials and guids at w3schools.com but couldnt find what i was looking
    for. All I really need is a list of a few steps to take to get a general idea on were to start when
    makeing an application. I would appreciate any help you may have to offer.....
  17. Php, Mysql, Apache
    (4)
    ok, i am hosting a smf (simple machines forum) and in order to do so, i need apache, mysql and php
    installed. so i got apachefriends xampp. it works, but idk where to go from there. am i ready to
    just host and stuff. or do i need to do a couple more things. basically what i need is a guide on
    how to set up a php website. or just confirmation that all i have to do is load the files onto the
    website, then im ready to go. thank you....
  18. Some Mysql Basics
    (4)
    Greetings this tutorial will show you some mysql basics.. MySQL is one of the most used database. a
    simple config file at the top add this CODE <?php ?> after <?php add
    $username= "root"; // Username that has access to your database $password=
    ""; //Password that has access to your database $host = "localhost"; // The
    host where the database is (mostly this is localhost) $db = "databasename"; //
    The name of the database where you want to work with //connect to the database mysql_connect(....
  19. Simple Mysql Query Limiting
    (9)
    Simple MySQL Query Limiting CODE <?php // If mypage?limit=blah is not defined returs 5
    if ( $_GET['limit'] == NULL ) {     $limit = 5; } // Else else {
        $limit = $_GET['limit']; } $query = mysql_query("SELECT
    * FROM members LIMIT '$limit'") or die(mysql_error()); while
    ($sql = mysql_fetch_array ($query) ) {     echo
    $sql['mem_name'] . '<br>'; } ?> Have fun......
  20. Mysql Query
    (2)
    theres a bug somewhere in this query and i can't seem to find it. does anyone else see it?
    CODE $query = "insert into templates
    (tuid,tname,tdescription,template,archivedefault) values (1,'Sample Archive
    Template','A sample archive template that only shows the name of the article with a link to
    the default article viewer.','<a
    href='viewarticle1.php?aid=[id]'>[articletitle]</a>',FALSE&#
    41;"; ....
  21. Putting Data Of 2 Pages In Mysql At Once
    (1)
    suppose i have a page, page.php?part=1 there i have some text fields. user will give input, but
    after taking input, it will not put the data in mysql .. but it will take to the next step..
    page.php?part=2 (if any field is left blank, it will not go to next page.. ) . and there also some
    fields.. after the user has filled that form also, then it will insert all data (from part1 and
    part 2) in mysql. i want to ask, how i can collect data from 2 pages and put in mysql at once.....
  22. Editing Information In A Mysql Database And Deleting Rows
    (5)
    I need help with a couple of things. First, I need to know how to retrieve information from a mysql
    database and edit it then re add it to the database. I also would like to know how to easily delete
    a mysql row. And I want this done without going to phpMyAdmin. Thanks for the help!....
  23. Importing .csv Into Mysql Database
    NEED HELP! (6)
    I need help importing a .csv contents into a Mysql database. I have this. But its not working.
    CODE <?php connection = mysql_connect("******", "**********",
    "********") or die ("Unable to connect to server"); $db =
    mysql_select_db("b9_259782_CC", $connection) or die ("Unable to select
    database"); fopen ('csvranks.csv', 'r');
    mysql_query("INSERT INTO test_table (id, name, guild, level, exp) ?> What
    am I doing wrong? The mys....
  24. How To Delete A Row In Mysql.
    A very simple help required (4)
    Im using the following code, for very simple work.. it simply gets and print the comments which are
    stored in the database. Now it will show like comment 1. comment 2. comment 3. etc etc i want to
    add 'delete' option that i can delete any comment. it displays like comment 1.
    Delete comment 2. Delete comment 3. Delete
    So that when i click on delete, it simply deletes the comment and print the remaining comments. Its
    very simple. i hope you understand. QUOTE $result = mysql_query("sele....
  25. Script Not Working :s
    mysql errors (5)
    process_login.php: Process the login. $host = "localhost";// the host that u are connecting
    $username = "root";// user name $password = ""; // passworld $basedatos =
    "forum"; //Dont change this1. $db = mysql_connect($host, $username, $password);
    mysql_select_db($basedatos, $db); $user= $_REQUEST ; $pass=
    md5($_REQUEST ); $query1= "SELECT * FROM smf_members WHERE
    memberName='$user'"; $mkquery= mysql_query($query1,$db); $row1=
    mysql_fetch_assoc($mkqu....
  26. Php Search Engine Script For Mysql Database
    (11)
    A search engine is provided to facilitate the user with undemanding and clear-cut search options.
    The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
    user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
    history of recent searches can be preserved for future perusal. Now
    day’s visitors have a large option for his needs on internet and so visitors are not vesting their
    time by following the dead links on your site. So a search engine is essential for your....
  27. Creating Profiles In Php/mysql ?
    (7)
    i've started to learn php..im familiar to basics of php and mysql now.Now for example i want
    that some user can register to my website , and after that he can Login and log out , and he can see
    his profile.is there any tutorial about this ? or any helping url .. or any helping answer please
    /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
  28. Can You Add Images Into A Mysql Database?
    Using Php? (20)
    I'm learning php in class right now, but I'm still not that good at it, what I'm
    wondering is when I write the php so that it can connect with a database, can I at the same time
    have it that it is able to display back images that I choose. Like, I want a search feature, where
    you can search for a keyword, and it will bring back a list of all the possible entries with that
    keyword, but each of these entries will have a photo associated with it. Now, do I put these image
    files directly into the database, or do I write the code to link them from my files to th....
  29. Increment A Mysql Column
    how to increment a MySQL column one unit (6)
    Hi, I have a column in a MySQL table which contains a counter of the views of the object described
    by this table. I would like to increment this value by one everytime the object is viewed. Obviously
    came into my mind the possibility of retrieving the value of this field, store it in a variable
    increment this value by one and perform an UPDATE query again with this new value. My question is if
    there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
    understand the issue.....
  30. Problem On Mysql "order By"
    (5)
    Can someone please help...? I have a problem with using "ORDER BY" in mysql... CODE SELECT *
    FROM `foo` WHERE b='abc' ORDER BY 'number' ASC i want to sort the table out by
    the value in "number" which is a number.. but it came out to be sort by like this way...
    1->10->2->20 it only sort out the front digit.... but what i want is it will sort by how great the
    number is like this... 1->2->3........->10....->20 sorry my english isn't good enough...to
    describe my problem properly... hope you can understand and help me on this.....thx....


      31. Looking for bug, php, and, mysql, bug, php, and, mysql

Searching Video's for bug, php, and, mysql, bug, php, and, mysql
advertisement



Bug In Php & Mysql - bug in Php & Mysql



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!" 		Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE