Web Wiz Forums - Error when adding a new topic

Print Page | Close Window

Error when adding a new topic

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29933
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error when adding a new topic

Posted By: eletronicashow
Subject: Error when adding a new topic
Date Posted: 08 November 2011 at 2:37pm

Este erro aparece somente quando tento criar um novo tópico

This error only appears when I try to create a new topic

Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the Forum Administrator.

Support Error Code:- err_Access_save_new_topic_data
File Name:- new_post.asp
Forum Version:- 10.03

Error details:-
Microsoft JET Database Engine
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 08 November 2011 at 2:55pm

The error means the database is corrupted.

Try downloading the database and compact and repair it in Access, if that does not fix it you would need to roll back to the last backup you did of the database.

Access is a desktop database and often becomes corrupted which is why you should use the SQL Server or mySQL versions.

Access is OK for small forums with a handful of members, under 10MB in database size, and only a limited number of hits each day.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: eletronicashow
Date Posted: 08 November 2011 at 3:12pm

Já tinha feito a compactacao do banco de dados mas sem resultado

mas já resolvi o problema quando eu atualizaei uma mensagem está gerou um registro na tabela tbltopic sem autor_id sem tread_id... somente exclui e voltou ao normal.

I had already done the compaction of the database but to no avail

but it solved the problem when I Upgrades a message isgenerated a record in the table without tbltopic autor_id tread_idwithout ... only deletes and returned to normal.

me disculpe pelo inglês porque estou usando um tradutor online mas como eu faço para converter para mysql o banco de dados.

Posted By: WebWiz-Bruce
Date Posted: 08 November 2011 at 3:46pm

mySQL is not a relational database like Access and SQL Server and uses different data types and date formats. Moving to mySQL would be very difficult.

What is much simpler is upsizing the database using Microsoft Access to SQL Server, as Access and SQL Server are both relational databases and use very similar data types.

Posted By: eletronicashow
Date Posted: 08 November 2011 at 5:08pm

se eu usar o upgrade as informações do access não passariam para o mysql.

if I use the upgrade information from unauthorized access pass for mysql.

Posted By: eletronicashow
Date Posted: 10 November 2011 at 9:55pm

deu um baita trabalho mas consegui transferir todos os registros do access para base de dados mysql usando um programa que gera um arquivo txt contendo todas as informações relativas ao conteudo do access a unica coisa que não consegui fazer funcionar foi os feed de noticia.

gave a hell of a job but managed to transfer all records of access to mysql database using a program that generates a txt file containing all information relating to the contents of access the only thing I could not make it work was the news feed.