What's new

Closed Ano error guys at pano po eto ifix ? need help lang po talaga, thank you.

Status
Not open for further replies.
D

Deleted member 622421

Guest
Error
SQL query:


CREATE TABLE `orderdetails` (
`order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`order_name` varchar(1000) NOT NULL DEFAULT '',
`order_price` double NOT NULL DEFAULT '0',
`order_quantity` int(10) unsigned NOT NULL DEFAULT '0',
`order_total` double NOT NULL DEFAULT '0',
`order_status` varchar(45) NOT NULL DEFAULT '',
`order_date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`order_id`),
KEY `FK_orderdetails_1` (`user_id`),
CONSTRAINT `FK_orderdetails_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1



MySQL said: You do not have permission to view the full content of this post. Log in or register now.

#1005 - Can't create table `edgedata`.`orderdetails` (errno: 150 "Foreign key constraint is incorrectly formed") (You do not have permission to view the full content of this post. Log in or register now.)



mga sir help po , yan po naging error nung nag'import po ako ng database sa xampp/mysql...
 
It's a foreign key checking sir. try mo off muna yung option para makapag execute ka ng create table mo.

SET FOREIGN_KEY_CHECKS=OFF;

Or manually, check mo yung collation property or try mo muna wag explicit yung int sizes mo. instead of something like int(11) try int lang. pero try mo muna off yung foreign key checking sir since nag migrate ka kamo.
 
It's a foreign key checking sir. try mo off muna yung option para makapag execute ka ng create table mo.

SET FOREIGN_KEY_CHECKS=OFF;

Or manually, check mo yung collation property or try mo muna wag explicit yung int sizes mo. instead of something like int(11) try int lang. pero try mo muna off yung foreign key checking sir since nag migrate ka kamo.


sobrang thank you sir, big help po :)
 
Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\appliances\Customers\shop.php on line 306

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 317

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 320


Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 353

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 353


eto po kaya sir ? pano po kaya eto mafix ???
 
Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\appliances\Customers\shop.php on line 306

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 317

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 320


Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 353

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\\Customers\shop.php on line 353


eto po kaya sir ? pano po kaya eto mafix ???


I think anjan na yung sagot sa error sir. try to observe na lang po.
 
di ko talaga maresolve boss , ano ba ibig sabihin ng error na yan ??

nako sir, mahirap yung spoon feeding. sabi jan sa error, expecting atleast 2 parameters so ibig sabihin, may ibibigay kang arguments sa loob ng function na mysqli_select_db(). It should be something like mysqli_select_db(parameter1_dito, parameter2_dito) or in real coding dapat ganito sya:

mysqli_select_db(DB_NAME,$connection);

Sa mga iba mong error, ganyan din ang problema.

magbasa ka ng basics ng language na gamit mo sir, I believe php gamit mo e. dl ka ng ebooks nyan or any tutorials for basics para mapagaralan mo sya ng maayos.
 
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 317

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\Customers\shop.php on line 320


Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 353

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\Customers\shop.php on line 353
 
o tatlo na lang ang error set. so na resolved na yung isa na binigay ko ang tips. try mo ng resolve yang tatlo na yan sir since na explain ko naman na sayo yung ibigsabihin nung error.
 
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 317

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\Customers\shop.php on line 320


Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\appliances\Customers\shop.php on line 353

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\appliances\Customers\shop.php on line 353


o tatlo na lang ang error set. so na resolved na yung isa na binigay ko ang tips. try mo ng resolve yang tatlo na yan sir since na explain ko naman na sayo yung ibigsabihin nung error.
 
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\appliances\Customers\shop.php:305 Stack trace: #0 {main} thrown in C:\xampp\htdocs\appliances\Customers\shop.php on line 305

sir help isa nalang po....
 
okay na naresolve ko na boss , dhil pala sa version ng xampp ko hehehehehe
 
boss pano mag per category ng products na iddisplay sa loob ng product.html
 
Status
Not open for further replies.
Back
Top