Creating Database

Hi All, To be honest, I don't know if my inquiry fits within this forum, but I really had no idea where to post what I need. I am currently interning at a non-profit nature center which relies heavily on volunteers. As art of my internship, my supervisor would like several databases created. I don't know what program would work best for my needs and I was hoping somebody could give me a few ideas for what I need to create. Here is what she would like: 1. A volunteer database that is searchable by the training and expertise each volunteer has received. Let's say for instance, that we are having an insect program and only those who have been trained for the program can volunteer. I need to be able to search a keyword or from a drop down menu individuals who have received this training. A spreadsheet would suffice, but some individuals have so many training sessions that it would get a bit long. We also have over a hundred volunteers. 2. A teacher database that shows the grades and classes each teacher in our system teaches. We have school groups come out, and if their is a fourth grade program, there is no reason to contact every other grade teacher. 3. This is the really challenging one. We have rental programs, and all users must complete rental information which includes name, contact information, type of rental, and emergency contact. I would like to go paperless with this and if somebody rents more than once they have to fill in the information every time. I would like to be able to search their name and have all of their information come up, then input their rental type and time, which would give me a list of how many rentals we have had per day/week/year and how much money we have made. As I said, I could just make a spreadsheet for the first two but I would like something a bit more sophisticated. If I was not clear about anything, please let me know.

Posted by Blinktwice 4 years ago


Database problems are causing the site to be slow

We're having some database problems, and they are causing the site to be slow. We're working as fast as we can to correct the issue. Sorry!

Posted by ewilhelm 8 years ago


Knex Database

Hey, I thought of programming a knex database on my website where everyone can enter there models so it's easy to find also other stuff... But here's the question to you guys: would that be needed?

Posted by Sorunome 6 years ago


how can i make a database for visual basic?

I'm trying to make a program that will keep track of my emulators and roms and some information about them. i'm a beginner and i was wondering what i need to use so i can make the database or if there's something else i can do, Thanks in advance for the help

Asked by coldpsyco91 8 years ago


The Microsoft JET Database Engine could not find the input table or query? Answered

I have a strange problem which suddenly appeared in my Access database. .mdb file involve tables, forms and reports and a code. Of course it splitted into two different files. From time to time i make any changes in them and everything was perfect. BUT recently these files damaged. I started get a rubbish in my table field first, and pops up an error message while trying open any form or report after. The error is: The Microsoft JET Database Engine could not find the input table or query ''. I am sure it exists and the name is spelled correctly. What is the problem and how can i solve it?

Asked by SapphireIguana 3 years ago


how would i go about creating an electronics parts salvage list/database?

As everyone should be doing some form of recycling I'm Planning on creating a sort of database of electronic parts and where they could be salvaged them from. I was wondering how I might do it and if anyone else had done this?

Asked by cyberraxx 7 years ago


How to connect an RFID card with a database?

Hello. I have been able to successfully read data from my RFID card using the card reader but I cant seem to connect my RFID card with my database that I have created using Microsoft Access and Visual Studio 2010. I want to be able to use my card to read data from the database when i swipe it and also be able to store data back to the card in order to update the information on each card. Please how do i go about this? I am using an arduino uno board and an RDM 6300 RFID reader 125kHz.

Asked by rasy09 3 years ago


Download entire ible database?

Was wondering if it's possible to download Instructables, in its entirety, like you can (and I just have) with Wikipedia? I'm looking to spend the next year or two doing appropriate tech and infrastructure building in various places, and thought it might be helpful having access to ibles from my usb drive if I'm away from the internet.

Posted by SolarFlower_org 7 years ago


mysql database got corruption?

Hi all, It seems that whenever I restart my Windows 7 64bit box MySQL gets corrupt. I just wanted to make this bug known as it's a serious issue. Are there any special settings I need to setup (task scheduler) to prevent this from happening? Is there a way to inform windows to shutdown MySQL? Thanks for any help.

Asked by norbertosolares 3 years ago


ERROR 400: Error retrieving featured Forums

This is probably just a temporary database glitch, but I thought I'd get it documented.  I tried to access Eric's "How do you like the new editor?" forum topic just now (7 Oct 2009 10:30 AM PDT), and got the error message quoted in the title.

Posted by kelseymh 8 years ago


I need an iTunes-style database solution for all my videos...

Hello, Newby to Instructables, read about it in the newspaper today.  Looking forward to some help/input on this project of mine... I have a huge (and growing) volume of video media. pushing 5 TB, and I'll be buying another 2 TB drive before autumn.  Now, having all this media at my fingertips on my PC without having to rifle through my DVD library is great, but it's only half the battle.  What I really want to be able to do is search through all my videos and TV episodes with the same ease that I go through my music library in iTunes. So, what I need is some way to list each video, and list each "tag" that applies to that video (SciFi, TV, comedy, romance, etc., you get the picture).  So, Excel serves well enough for that part, though I'm not married to it as a long-term solution. And, Excel fails completely as a searchable database, where I can just type in, say, "SciFi" and get the database to present me with every single Start Trek, Stargate, B5, etc. TV episode and movie that I own. So, can anyone suggest a program that would already be able to do this for me? iTunes itself isn't a solution, because although I could  make a plethora of empty MP3 files, import them into iTunes, and assign all the metadata I want to them, there wouldn't be anyway to click on the empty MP3 entry and have the movie/video pop up and play. Also, my videos are either direct DVD rips or mkv files, so I can't import either of those into iTunes either. Thanks in advance!

Posted by draco963 5 years ago


Why is the Answers summary page still running an hour or more late?

It seems that the Summary page listing recent Questions/Answers is roughly an hour behind schedule. When I post an answer, or flag a Best Answer, the summary page remains indifferent (even after multiple reloads) for a substantial time.

Posted by kelseymh 9 years ago


mysql server does not want to get some packages because of error 'Packet Too Large'. How to fix? Answered

For some reason i unable to receive a packet sent on MySQL 4.5 server. Trying to get it MySQL just shows me an error "Packet too large" and closes the connection. Namely this situation is not so bad, i can receive the packet partially, after all. But to prevent such issues i want to know what should i do to increase the receiving option. I suppose there are some kind of limitation, it would be logical. I have not seen such error just because i used to handle small-sized packets. Is it possible? And if it is, how can i change my client settings or use some commands or what? =)

Asked by Necrosyse 3 years ago


Database important data

I was working on MS Access 2003 database during all the past day. I saved my changes in database and closed the application. After second opening, my changes lost, I checked this one more time, but I couldn't get it back.

Asked by CallumSuttonSS 3 months ago


Is a complete Database Download of Instructables available? Answered

I was wondering, because it takes so long to download all my favourites, and wouldn't it be easier to download all of it and look around for the best?

Asked by bethekind 5 years ago


Is showing the user SQL error messages dangerous? Answered

If during error conditions your website shows a page full of SQL messages, does this put you at greater risk of an injection attack?

Asked by NobodyInParticular 9 years ago


Why does it take 45 minutes to an hour for the RECENT answers page to match the actual set of answers and Best flags? Answered

Answer this question, then look at the summary page. If you're patient, periodically refresh it with your browser's [Reload] button, and see how long it takes to show "1 answer."

Asked by kelseymh 8 years ago


Need to recover access database with superior solution to fix access database errors? Answered

I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

Asked by lawsonoliver1 3 years ago


Database file appears corrupt. What to do? Answered

There are some apps which use VFP 9.0. I needed to make some changes in the database file, but I was unable due to error. It says: "Database file appears corrupt: Page XXXX is of wrong type". I have no backup therefore I can`t retrieve the file back. How can I fix this error? Any tipps?

Asked by Tongbang 3 years ago


Need help with excel spreadsheet?

I have a spreadsheet that i'd like to convert into an exe/ visual application. I have no programming experience, is there a simple converter available or what? thanks in advance.

Asked by musick_08 6 years ago


Excel XLS inventory integrated circuit list - trying to not reinvent the wheel- chip database

Trying to find a simple inventory system to keep track of my integrated circuits. Prefer Excel part number versus function, Thanks

Posted by naic98 7 years ago



Knex Gun Database Open To New Members

Created December 2011, the Knex Gun Database is a wiki (open to editing by any member admitted into the group) that stores all the knowledge on knex guns. It's purpose is to quickly bring new knexers up to speed on knex gun building so that they do not duplicate past inventions and can therefore can continue to push the community forward and innovate. TheDunkis and I (Oblivitus) believe that this is ESSENTIAL to the future of knex guns. If you would like to join us in this noble endeavor please go here: http://knexbuilding.wikispaces.com/ Sign up for an account and request to join the group. Please follow the formatting that all the other pages use. Thanks for your help! With your support, we can move knex gunning forward! If you are reading this, than copy, paste, and re-post this entire block of text in your own forum to get this message to everyone. Thank you, Oblivitus

Posted by Oblivitus 6 years ago


How do I display specific rows from a SQL database using $_GET? Answered

For my latest website, I have created a MySQL database to store user-submitted data. Currently for the homepage a PHP script connects to the database and selects a random row to display on the page. The table is set out like this: ID               Quote                 Author                Category 21              blah                    anonymous        Life 22              hdhshs               anonymous        Food I wanted to create a page where when a user goes to www.example.com/post.php?id=45 , it displays the row with the ID number of 45. That I have done successfully. But now I want to create a page where if you go to, say: www.example.com/cat.php?catergory=Life, where it lists all rows under Life. But after tweaking the code for the Post page, it doesn't seem to work. Code for Post Page: $user="**********"; $password="**********";$database="**********"; $connection=mysql_connect('**********',$user,$password);@mysql_select_db($database) or die( "Unable to select database");  $sql = "SELECT * FROM `quotes` WHERE `id` = " . mysql_real_escape_string ( $_GET['id'] );  mysql_select_db ( $database, $connect ); if ( @mysql_query ( $sql ) )  { $query = mysql_query ( $sql );   $row = mysql_fetch_assoc ( $query );   echo '' . $row['quote'] . '#' . $row['id'] . ''; }  else { die ( mysql_error () );  }?> What do I need to change in the above code, to display a list of every row in the database with a category of whats in the URL?  This is my first time running a MySQL database, so sorry if the code is a bit squiffy.

Asked by asasklfjklasfkljasklfjaklfsjkl 7 years ago


How can i set up my personal wiki?

I downloaded WAMP, and MediaWiki. everything is set up except when i try to install Mediawiki it says that there are authentication errors and that i need to check the passwords, i've tried changing the password but it doesnt work, and the mysql website hasn't helped. what else should i try?

Asked by coldpsyco91 7 years ago


Is an Instructables Database Download possible? Answered

Is there a way to download the entire Instructables database for offline viewing, mirroring and/or backing up?Yes, I realize how big such a download would be. Nothing compared to Wikipedia's, though... And yes, I do realize that there are "download PDF of Instructable" link. I'm talking about a "Download ALL Instructables" link.Or be able to order a stack of CDs/DVDs... That would work too...

Asked by robotguy4 8 years ago




Problem with Virtual Patches database?

Did something go wrong with the Virtual Patches database at the turn of the year? Ed had given my my patch for the Best-of-I'bles book, but now it's gone (I still have the Robot Art patch). I've checked a couple of other users known to have the book, and the patch is missing from their profiles as well. UPDATE: This morning, everything seems to be back to normal. Should have updated before Noah took up his time posting :-/

Posted by kelseymh 9 years ago



Creating an Invention and Instructable Mixing Software or Website

I was wondering if we could create a new website device, we could call it the Invention Mixer Software.It would basically be a large database of practical or groundbreaking inventions, and maybe many of the instructables here.We could arrange it according to use (Renewable Energy, Agricultural, Games, etc) and we could arrange it like a shopping cart selection. Each item would contain Name of Invention, Its basic use and advantage over common inventions, and the link to the manufacturer or institution doing the research.With the shopping cart, you can choose the inventions and instructables you like and store them in the website, or copy and paste to your friends to discuss,compare or talk over.It would be more than hobbyists website. People making new inventions could compare with the products now in the market, and compare it to instructables that can make similar inventions.It would be like a cheap, low cost utility compared to the very powerful but expensive invention making machines like:INVENTION MACHINE Softwarehttp://www.invention-machine.com/productsservices.aspxor stuff like this:CREAX Invention Softwarehttp://www.creax.com/innovation_software.htmThis would be the every man's invention software on a website.

Posted by mikedu 8 years ago


Access 2010 database manual Answered

Today I had one client with the damaged .mdb file. I asked him about the backup, but he said that he were not made these settings and, accordingly, the backup was not done. The base was created in Access 2010 on the operating system Windows 7. What do I do to restore it?

Asked by lestermathews 1 year ago



Cataloging School Papers

I spontaneously decided to catalogue every paper I get/do in school this year. I've run some tests with tesseract, a OCR program, and its decent. Except... I don't have a scanner... I'm thinking of giving it up, unless someone else would like to also try it out. If so, I'll put effort into procuring a scanner, or figuring a way to emulate one with a camera. Any random thoughts on this?

Posted by zachninme 10 years ago


Calling all VBScripters!

I am trying to create a vbs script that will use vocabulary databases to randomly choose words according to sentence structure, then using a large database (that tells what words are relevant to the random word chosen) it creates a basic sentence. With more complicated sentence structures there are more complicated. I need some other vbscripters to help. Here is how it works The program chose a statement sentence. The basic structure is noun verb Then the program choses a word Cats verb Finally using the matching database it creates a realisitic sentence Cats meowed. A more complex sentence would be article noun verb preposition pronoun noun article cat verb preposition pronoun noun article cat called preposition her kittens article cat called to her kittens The cat called to her kittens 

Posted by Super_Nerd 6 years ago



how to integrate temperature, pressure, humidity sensors included with a time stamp into a single table in MySQL db??

I am new..  i want detailed step to step process and code of how to integrate temperature sensor,pressure sensor,humidity sensor included with time stamp into a single table in a database. i want these values into the MySQL database every 15 mins once..

Asked by arjund2 3 years ago


Updated e-mail address doesn't change in the newsletter mailing

Changed my profile's e-mail address and confirmed it, and it shows under my profile. However I still get newsletter e-mails under the old e-mail address. I assume they're two different databases, but then how do I delete the old address from the newsletter mailing database?

Posted by SAVAJ 8 years ago



I had a SQL that got destroyed by someone re-initializing the disks on a RAID array and destroying the data. Answered

I have managed to restore the DB from a very old backup, and I tried replacing the MDF and LDF files with the ones that I recovered from a backup.  The problem is that the new MDF and LDF files were not detached in the copy that I have, so when I start up the SQL server EM shows the DB as Loading/Suspect.  I have tried restoring the database using sp_attach_db, sp_attach_single_file_db.  I get the error The log for database DBName is corrupt' when I use sp_attach_db, and when I use sp_attach_single_file_db I get the error 'Database 'DBName' cannot be opened because some of the files could not be activated'

Asked by lalifes53 3 years ago


Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there some operations which are not logged in Bulk-Logged Recovery Model compared to Simple Recovery Model?

Asked by bugarl 3 years ago



MySQL said: Documentation (Errcode: 17)?

I have several mySQL databases on a dedicated server that appear to be corrupt. I am getting the error: MySQL said: Documentation #1 - Can't create/write to file '#sql_e6e_0.MYD' (Errcode: 17) when I try to access any table in any database. I can export the data and it looks ok, but when I delete the table and import it back I still get the error. If there is a way to fix this please provide me with step by step instructions.

Asked by FrankKelly 2 years ago




Why do my Answers keep disappearing and reappearing?

No, I haven't said anything rude, irrelevant, illegal, commercial, or otherwise spammy. Is this just a strange SQL database glitch?

Asked by 9 years ago



How do I edit a SQL database? Answered

Hey, I have recently found a clone of the Fiverr Script micro-jobs thing for free and I have no idea of how to set it up. I have set up the installation it says and step 2 says I need to import a file called 'scriptsolution.sql' into my newly created database. I know what this means, but how do I do this? I have setup a MySQL database on http://www.freesqldatabse.com/ and I don't know how to edit it. Then, step 3 says I need to upload some specified files into my web server's public directory and I have no idea on how to do that or what that means. Step 4 says I need to CHMOD 777 the files and directories that it shows, I have no idea what that means. Lastly, step 5 says 'Setup a cron job on your server to run once every hour of every day.' and it says the commend format, I sort of know what this means but I don't know how to do this. That's all I have questions abou so PLEASE HELP!!! Thanks!

Asked by knexpert1700 5 years ago



Brassgoggles steampunk site is down?

I know they many people who visit this site also visit brassgoggles.co.uk and the accompanying forum, and i know there's quite a lot of overlap between these two sites, with members migrating here, to show off their work, for example; Heresyoftruth and aintmicheal. For the past few days, i've not been able to access the site, nor its forum from any of the computers i've tried with. All i get is a screen that tells me: "Error establishing a database connection This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at 213.171.218.251. This could mean your host's database server is down." Does anyone have any idea what's going on? Has anyone heard from a moderator, or do they know where i can contact a mod? I'm starting to get worried about this.

Posted by Vendigroth 10 years ago