Skip to main content
3 votes

phpMyAdmin: "mysql extension missing" error

We all know that phpMyAdmin can be flaky sometimes. Unfortunately, I can't tell you how to fix it -- but I can tell you how to use mysql50 shell from the command line. Try stuff like this: mysql50 ...
hotwebmatter's user avatar
  • 3,050
1 vote
Accepted

Pset7 (Movies) 12.sql: Table outputs 96 rows rather than 5 rows

Using a previous post on this forum, I was able to deduce I had to use the INTERSECT operator, which instantly solves the problem.
qwert9988's user avatar
1 vote

Where is the syntax error in this sql file?

Unless I'm missing something, that is not a sql query. A sql query is something like "SELECT columns FROM table WHERE condition". That is html code.
DinoCoderSaurus's user avatar
1 vote

Locked out of phymyadmin

This seems to have resolved itself by restarting the development environment.
Samuel Oscar Frances's user avatar
1 vote
Accepted

Duplicate entry Error when inserting into portfolios pset7

OK... looks like there is a quick fix this that it was not implicit in the description. By adding ALTER TABLE yourtablename ADD CONSTRAINT uq_yourtablename UNIQUE(column1, column2); it seems that the ...
JaviMar's user avatar
  • 125
1 vote
Accepted

pset7: query(INSERT) return value?

You are not calling PHP mysql_query(). You are calling CS50::query. From the pset specification/instructions: If query is instead passed a DELETE, INSERT, or UPDATE statement, it will return a non-...
DinoCoderSaurus's user avatar
1 vote
Accepted

How to make search.php return results that are more relevant

It's as simple as turning this and obviously I would prefer "Cincinnati, OH" to be the first result. into computer code :) Kinda moves into the realm of computer learning/intelligence. First ...
DinoCoderSaurus's user avatar
1 vote

pset7 problem with buy and portfolios table

Without seeing the details of your user table, or knowing if you have any foreign keys to that table, I can't be sure, but I'm fairly confident that your problem is in your primary key. I'm guessing ...
Cliff B's user avatar
  • 69.2k
1 vote

How should I connect to the multiple databases?

Admittedly I don't fully grasp what you mean "merge several psets". However,in the narrow and specific context of CS50 pset7 & pset8, you do not need two databases. Consider adding the places ...
DinoCoderSaurus's user avatar
1 vote
Accepted

MySQL Query function not working

$username is blank as per the error message: Access denied for user ''@'localhost'..... . There is nothing between the two ticks (single quotes) after user. That makes $password, $dbname suspect as ...
DinoCoderSaurus's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible