1262680 - rico

Status: RESOLVED INVALID

(Invalid Bugs :: General, defect)

Description

[Rico Renandiansyah]

Attachment: db_project.sql

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36

Steps to reproduce:

bllll


Actual results:

kkkk


Expected results:

kmkmk

Comment 1

[Rico Renandiansyah]

Comment on attachment 8738853 [details]
db_project.sql

>-- phpMyAdmin SQL Dump
>-- version 3.5.1
>-- http://www.phpmyadmin.net
>--
>-- Host: localhost
>-- Generation Time: Feb 14, 2013 at 12:09 AM
>-- Server version: 5.1.36-community-log
>-- PHP Version: 5.4.3
>
>SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
>SET time_zone = "+00:00";
>
>
>/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
>/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
>/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
>/*!40101 SET NAMES utf8 */;
>
>--
>-- Database: `db_project`
>--
>
>-- --------------------------------------------------------
>
>--
>-- Table structure for table `tb_products`
>--
>
>CREATE TABLE IF NOT EXISTS `tb_products` (
>  `productID` int(11) NOT NULL AUTO_INCREMENT,
>  `name` varchar(30) NOT NULL,
>  `description` text NOT NULL,
>  `category` varchar(30) NOT NULL,
>  `originated` text NOT NULL,
>  `price` int(11) NOT NULL,
>  `quantity` int(11) NOT NULL,
>  `location` varchar(200) NOT NULL,
>  PRIMARY KEY (`productID`)
>) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
>
>--
>-- Dumping data for table `tb_products`
>--
>
>INSERT INTO `tb_products` (`productID`, `name`, `description`, `category`, `originated`, `price`, `quantity`, `location`) VALUES
>(1, 'john djaskdak', 'e', 'e', 'e', 5, 5, 'upload/'),
>(4, 'g', 'e', 'e', 'e', 7, 7, 'upload/beautiful-girl.jpg'),
>(3, 'q', 'q', 'q', '', 1004, 3, 'upload/wine4.png'),
>(5, 'q', 'e', 'r', 'r', 7, 7, 'upload/wine-farm.jpg'),
>(9, 'b', 'b', 'b', 'b', 0, 6, 'upload/'),
>(10, 'k', 'k', 'k', 'k', 0, 4, 'upload/bg-page.png'),
>(11, 'dasda', 'dasd', 'd4', 'ada', 56, 89, 'upload/bg-wooden.jpg'),
>(12, 'asd', 'fhsajhf', 'fashfj', 'fhaj', 6, 50, 'upload/');
>
>-- --------------------------------------------------------
>
>--
>-- Table structure for table `tb_user`
>--
>
>CREATE TABLE IF NOT EXISTS `tb_user` (
>  `user_id` int(11) NOT NULL AUTO_INCREMENT,
>  `username` varchar(100) NOT NULL,
>  `password` varchar(100) NOT NULL,
>  `firstname` varchar(100) NOT NULL,
>  `lastname` varchar(100) NOT NULL,
>  PRIMARY KEY (`user_id`)
>) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
>
>--
>-- Dumping data for table `tb_user`
>--
>
>INSERT INTO `tb_user` (`user_id`, `username`, `password`, `firstname`, `lastname`) VALUES
>(1, 'teph', 'teph', 'stephanie', 'villanueva');
>
>/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
>/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
>/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Comment 2

[Rico Renandiansyah]

(In reply to Rico Renandiansyah from comment #1)
> Comment on attachment 8738853 [details]
> db_project.sql
> 
> >-- phpMyAdmin SQL Dump
> >-- version 3.5.1
> >-- http://www.phpmyadmin.net
> >--
> >-- Host: localhost
> >-- Generation Time: Feb 14, 2013 at 12:09 AM
> >-- Server version: 5.1.36-community-log
> >-- PHP Version: 5.4.3
> >
> >SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
> >SET time_zone = "+00:00";
> >
> >
> >/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> >/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> >/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> >/*!40101 SET NAMES utf8 */;
> >
> >--
> >-- Database: `db_project`
> >--
> >
> >-- --------------------------------------------------------
> >
> >--
> >-- Table structure for table `tb_products`
> >--
> >
> >CREATE TABLE IF NOT EXISTS `tb_products` (
> >  `productID` int(11) NOT NULL AUTO_INCREMENT,
> >  `name` varchar(30) NOT NULL,
> >  `description` text NOT NULL,
> >  `category` varchar(30) NOT NULL,
> >  `originated` text NOT NULL,
> >  `price` int(11) NOT NULL,
> >  `quantity` int(11) NOT NULL,
> >  `location` varchar(200) NOT NULL,
> >  PRIMARY KEY (`productID`)
> >) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
> >
> >--
> >-- Dumping data for table `tb_products`
> >--
> >
> >INSERT INTO `tb_products` (`productID`, `name`, `description`, `category`, `originated`, `price`, `quantity`, `location`) VALUES
> >(1, 'john djaskdak', 'e', 'e', 'e', 5, 5, 'upload/'),
> >(4, 'g', 'e', 'e', 'e', 7, 7, 'upload/beautiful-girl.jpg'),
> >(3, 'q', 'q', 'q', '', 1004, 3, 'upload/wine4.png'),
> >(5, 'q', 'e', 'r', 'r', 7, 7, 'upload/wine-farm.jpg'),
> >(9, 'b', 'b', 'b', 'b', 0, 6, 'upload/'),
> >(10, 'k', 'k', 'k', 'k', 0, 4, 'upload/bg-page.png'),
> >(11, 'dasda', 'dasd', 'd4', 'ada', 56, 89, 'upload/bg-wooden.jpg'),
> >(12, 'asd', 'fhsajhf', 'fashfj', 'fhaj', 6, 50, 'upload/');
> >
> >-- --------------------------------------------------------
> >
> >--
> >-- Table structure for table `tb_user`
> >--
> >
> >CREATE TABLE IF NOT EXISTS `tb_user` (
> >  `user_id` int(11) NOT NULL AUTO_INCREMENT,
> >  `username` varchar(100) NOT NULL,
> >  `password` varchar(100) NOT NULL,
> >  `firstname` varchar(100) NOT NULL,
> >  `lastname` varchar(100) NOT NULL,
> >  PRIMARY KEY (`user_id`)
> >) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
> >
> >--
> >-- Dumping data for table `tb_user`
> >--
> >
> >INSERT INTO `tb_user` (`user_id`, `username`, `password`, `firstname`, `lastname`) VALUES
> >(1, 'teph', 'teph', 'stephanie', 'villanueva');
> >
> >/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> >/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> >/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Comment 3

[:Gijs (he/him)]

This is a production bug tracker used by the Mozilla community.
Filing test bugs here wastes the time of all our contributors, volunteers as well as paid employees.
Please use https://landfill.bugzilla.org/ for testing instead, and don't file test bugs here.
If you continue to abuse this bugzilla instance, your account will be disabled.