Error when adding a new topic

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
eletronicashow Members Profile Find Members Posts Groupie Joined: 07 August 2009 Location: São Roque/SP Status: Offline Points: 33	Post Options Post Reply Quote eletronicashow Report Post Thanks(0) Quote Reply Topic: Error when adding a new topic 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

eletronicashow Members Profile Find Members Posts Groupie Joined: 07 August 2009 Location: São Roque/SP Status: Offline Points: 33	Post Options Post Reply Quote eletronicashow Report Post Thanks(0) Quote Reply 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.
WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

eletronicashow Members Profile Find Members Posts Groupie Joined: 07 August 2009 Location: São Roque/SP Status: Offline Points: 33	Post Options Post Reply Quote eletronicashow Report Post Thanks(0) Quote Reply 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.

eletronicashow Members Profile Find Members Posts Groupie Joined: 07 August 2009 Location: São Roque/SP Status: Offline Points: 33	Post Options Post Reply Quote eletronicashow Report Post Thanks(0) Quote Reply 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.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum