6 votes
Accepted

Pset7 missing mysql sock

I'm sorry if it's not appropriate to answer your own question but I'd like to post the solution to this problem just in case someone has the same issue. The commands sudo /etc/init.d/mysql start ...
user avatar
  • 97
2 votes
Accepted

Why can't I make this table? It shows an error

The problem looks like you are trying to create a table with two primary keys, one on column ID and one on column TIMESTAMP. A table is only allowed to have one primary key. You can have multiple keys,...
user avatar
  • 63.4k
2 votes
Accepted

pset8: phpMyAdmin - Error The mysqli extension is missing - can't get more frustrated than this

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 ...
user avatar
  • 3,035
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.
user avatar
1 vote

Locked out of phymyadmin

This seems to have resolved itself by restarting the development environment.
user avatar
1 vote
Accepted

problem in opening phpmyadmin and cs50 finance in pset7

There is a way to reset the IDE without fixing the PHP interpreter. You can create a new workspace. Go to https://cs50.io/sharmapranjal and click on the big gray square that says "+ Create a new ...
user avatar
  • 3,035
1 vote

Pset8 search add fulltext error

Fulltext index is only supported on columns that are either of type varchar, text, or char, and some others you likely won't use. latitude and longitude are both of type decimal. See this page, quote ...
user avatar
  • 1,223
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 ...
user avatar
  • 25
1 vote
Accepted

phpMyAdmin not working showing error:Token mismatch

The Error: Token mismatch has to do with your session authentication. Simply force-reloading the page with Ctrl+F5 might help. If that does not help, you could try clearing your cookies from cs50.io ...
user avatar
  • 3,035
1 vote
Accepted

phpMyAdmin in CS50 IDE (v 71)

OK, so I figured out what to do: Open a new Terminal tab in the IDE. Verify that mysqld is running: ~/workspace/ $ mysql50 status MySQL is not running. ~/workspace/ $ mysql50 start * Starting ...
user avatar
  • 3,035
1 vote

Getting the error Token mismatch when i click anything on phpmyadmin page and can't do anything on the site

Clear the cache on the browser!
user avatar
  • 61
1 vote
Accepted

phpymydamin warning

The PHP parameter session.gc_maxlifetime determines how long a php session will stay alive and is set in your php.ini file. It is probably 1440 [seconds] (24 minutes). The phpMyAdmin setting can be ...
user avatar
1 vote
Accepted

How to get phpmyadmin to work inside pset8?

the answer is of course to ensure that /etc/hosts is updated per the specs. see the "Getting Started" section! Next, in a terminal window, execute sudo gedit /etc/hosts in order to run ...
user avatar
  • 17.4k
1 vote
Accepted

http://pset7/phpMyAdmin is 404 not found

Try http://localhost/phpmyadmin I always accessed phpmyadmin using that url.
user avatar
1 vote

I can't access my table in phpMyadmin

I had this same problem and did find a resolution. After trying numerous suggestions and trying to recreate missing tables, it just went from one problem to another, without ever getting to a ...
user avatar
  • 63.4k
1 vote

Problem with creating a table in phpmyadmin

Open a Terminal and type mysql -u jharvard -p enter the password then typ show databases There should be one called pset7 so you can access it via use pset7 Then type show table and you should see the ...
user avatar
  • 11
1 vote

In pset7 error phpmyadmin phpmyadmin.pma_table-uiprefs

Just had the same problem. The comments give clues and partial answers, but not complete details. curiouskiwi provided a complete solution: 1) run sudo dpkg-reconfigure phpmyadmin in a terminal ...
user avatar
  • 63.4k
1 vote

Can't access the appliance from outside

If you're working on Windows 7 and the internet is working on the appliance properly, you should be able to access the appliance by Hit Windows Key + R from your keyboard to open up Run. Type\\w.x.y....
user avatar
  • 17.4k
1 vote

Can't access the appliance from outside

It depends on what kind of access you're shooting for, and how your virtual network is setup on vmware. I personally use bridged connection so the virtual machine has its own ip address rather than ...
user avatar
1 vote

When I try to use phpMyAdmin, I get a forbidden error

First thing first. From what you said, I assume you are trying to access phpMyAdmin from inside yur appliance. As a rule of thumb, ALWAYS run update50 when you start your appliance. If you get the "...
user avatar
  • 1,156
1 vote

When I try to use phpMyAdmin, I get a forbidden error

Just to back up a step. You are able to access http://pset7 okay? But http://pset7/phpMyAdmin gives you a forbidden? Did you chmod all the files as outlined in the pset instructions in the Getting ...
user avatar
  • 18.4k

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