| Author |
 Topic  |
|
JJenson
Advanced Member
USA
2121 Posts |
 Posted - 25 January 2007 : 14:59:50
|
Sorry if this has been covered I tried to repair a database I have in access. I open it and click on repair up in the tools it flashes then reopens up and I cannot tell if anything has happend?
The problems still exist within it so just wondering if I am doing this wrong? |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 January 2007 : 15:07:52
|
| What is "the problem?" |
 |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 25 January 2007 : 15:11:53
|
Basically I have one forum a family site I created and it was the first tinkering with the stuff in my entire life. I made lots of mistakes and honestly I don't know all of them. But now I have like the photo album mod installed and when I goto change settings within it it throws up a error saying
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/jenson2007/forum/inc_func_common.asp, line 181
I have this installed exactly the same way on every other forum I have done without any problems. but only on this first one so I assume it has to be the database having issues. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 25 January 2007 : 15:35:40
|
repairing an access db doesn't change field sizes, etc, it fixes torn pages.
looks like you've got a mismatch in data sizes, probably an insert statement is misaligned - what's on the few lines surrounding line 181? |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 25 January 2007 : 15:39:48
|
| the only weird thing about that pdrg is I have this running with the exact same files on multiple forums and none of those have this issue. Wouldn't that mean its not a code thing? I even took a inc_func_common file form one of the working ones and place it in the problem forum. Still same thing but on the site it came from works great? |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 January 2007 : 04:11:01
|
quote:
Originally posted by JJenson
Sorry if this has been covered I tried to repair a database I have in access. I open it and click on repair up in the tools it flashes then reopens up and I cannot tell if anything has happend?
That's exactly how it should work; the way to tell if it's made any difference is to check the size of the *.mdb file before opening then close Access after compacting and repairing it and check the file size again.
If you're using the exact same files on other forums without any problems then your problem lies in the database itself. If you post a link to your inc_func_common.asp file and e-mail me a link to you *.mdb file, I'll take a gander for you. Basically what's happening is that your query is trying to insert a string in a field that's too long for that field; for example, the string may be 50 characters long and that field may only accept strings that are no more than 20 characters long.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 26 January 2007 : 08:45:36
|
OK I will do that a little later. The problem lies in the characters already in place would be the number 10 I would change it to 15 and I get this error so there are only 2 characters but I will email that to you alittle later today and post a link to the t.txt version of the inc_func_common.asp
Thanks Shaggy |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 January 2007 : 08:47:09
|
That's easily fixed, crack open your database and jump into design for for the table that's throwing the error and modify the length of the field there.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 26 January 2007 : 08:58:53
|
Shaggy went to email you and there is no email option in your profile? Let me know I tried doing it in design mode but didn't work. THanks
Sorry meant to include this:
inc_unc_common.asp.txt:
http://www.thebragboard.com/downloads/inc_func_common.asp.txt
|
Edited by - JJenson on 26 January 2007 09:01:44 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 26 January 2007 : 09:04:17
|
| Were you having problems with the AU MOD prior to this? It looks like the error is in a function you added as a part of that MOD... |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 January 2007 : 09:07:14
|
quote:
Originally posted by JJenson
Shaggy went to email you and there is no email option in your profile?
E-mail turned on.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 26 January 2007 : 09:25:18
|
| NO problems with any mod on any of my forums. This is the only place and time it throws a bunch of errors including when I goto actually upload a photo it will not upload it in the right location. But everything else works wonderfully in all places. Seems strange to me. Oh Well |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 January 2007 : 10:43:26
|
Just got your database there, now, Jeff - unfortunately, I don't have access to Access at the moment (someone's just legged it with the laptop) so you may want to seek help from someone else 'cause I won't be able to look into it 'til Monday, now. Looking at your inc_func_common.asp, though, it's definitely one of the fields in your AU table, either AU_LASTACTIVETIME, AU_LASTPAGE or AU_QUERYSTRING, although you would have had to change the length of the field that's causing the problem after you installed the mod as it shouldn't be giving you this problem "out of the zip". Have you tried comparing the table against the AU table in one of your other databases, see if you can spot where the difference is?
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 26 January 2007 : 10:48:50
|
| No i actually didn't mainly cause active users is working properly. So didn't even really think of checking that. Will do tonight or this weekend. Thanks Shaggy. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 26 January 2007 : 10:51:10
|
| Hey Shaggy, someone here had pointed this program out a while back, and I've found it rather useful for checking on stuff. It won't let you edit the table properties or add/remove columns and stuff like that, but it will at least let you see the table structure and data. Since it doesn't need to be installed, I've started keeping a copy on my flash drive for emergencies. |
|
|
|
Topic |
|
Topic Locked
